Getting Error 9134 QGInitiatorImportContract: 40001 when trying to create a foreign server.

QueryGrid
Teradata Employee

Getting Error 9134 QGInitiatorImportContract: 40001 when trying to create a foreign server.

Getting the following error when trying to create a foreign server:

 

CREATE FOREIGN SERVER sdt14889_fs

EXTERNAL SECURITY DEFINER TRUSTED target_server_auth

USING

LINK('sdt14887_link_sdt14889')

VERSION ('active')

DO IMPORT WITH TD_SYSFNLIB.QGInitiatorImport,

DO EXPORT WITH TD_SYSFNLIB.QGInitiatorExport;

 *** Error 9134 QGInitiatorImportContract: 40001: (9c51dec2-9002-42f5-acfd

 -000000000008) Validate connection failed. java.sql.SQLException: JDBC connec

 tion failed. [Teradata Database] [TeraJDBC 16.20.00.02] [Error 8017] [SQLStat

 e 28000] The UserId, Password or Account is

 *** Total elapsed time was 1 second.


Accepted Solutions
Teradata Employee

Re: Getting Error 9134 QGInitiatorImportContract: 40001 when trying to create a foreign server.

The 'auth' object 'target_server_auth' has an invalid password.

Verify that the username and password are correct. Also verify that user exist in the target system and

if it doesn't, you will need to set it up.

1 ACCEPTED SOLUTION
1 REPLY
Teradata Employee

Re: Getting Error 9134 QGInitiatorImportContract: 40001 when trying to create a foreign server.

The 'auth' object 'target_server_auth' has an invalid password.

Verify that the username and password are correct. Also verify that user exist in the target system and

if it doesn't, you will need to set it up.