Attempt to establish connection failed with security - DB2
Attempt to establish connection failed with security - DB2
Hi
I can't connect with profileStage repository on DB2.
Could you explain me where is the problem?
SQL30082N Attempt to establish connection failed with security
reason "24"
("USERNAME AND/OR PASSWORD INVALID"). SQLSTATE=08001
Thank in Advance,
Anka
I can't connect with profileStage repository on DB2.
Could you explain me where is the problem?
SQL30082N Attempt to establish connection failed with security
reason "24"
("USERNAME AND/OR PASSWORD INVALID"). SQLSTATE=08001
Thank in Advance,
Anka
Have you been able to connect to that DB/2 instance from the command line with the same userid and password?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
I have problem to connect with DB2 when I am using Ascential driver.
When I used the IBM DB2 ODBC driver for connection to the repository in the Connection manager instead of the "Ascential" one, this test passes, but problem moves to the phase when I want to load DataBase Meta Data (I see in the log window I'm able to read data but I'm not able to load them into repository):
6.20 14:13:10: DEMOSERVER\GenOdbc2Mxf: 5039 0 Program GenOdbc2Mxf running. Computer: DEMOSERVER. Process ID: 400. Program ID: 6.
6.20 14:13:12: DEMOSERVER\GenOdbc2Mxf: 23 0 Program initialization is now complete.
6.20 14:13:12: DEMOSERVER\GenOdbc2Mxf: 5275 0 Getting approximate row count for table 'Categories'. This may take a while to complete.
6.20 14:13:12: DEMOSERVER\GenOdbc2Mxf: 5275 0 Getting approximate row count for table 'Cust_Info'. This may take a while to complete.
6.20 14:13:12: DEMOSERVER\GenOdbc2Mxf: 5275 0 Getting approximate row count for table 'Division'. This may take a while to complete.
6.20 14:13:12: DEMOSERVER\GenOdbc2Mxf: 5275 0 Getting approximate row count for table 'Employees'. This may take a while to complete.
6.20 14:13:12: DEMOSERVER\GenOdbc2Mxf: 5275 0 Getting approximate row count for table 'EmployeeTerritories'. This may take a while to complete.
6.20 14:13:12: DEMOSERVER\GenOdbc2Mxf: 5275 0 Getting approximate row count for table 'OrderDetails'. This may take a while to complete.
6.20 14:13:12: DEMOSERVER\GenOdbc2Mxf: 5275 0 Getting approximate row count for table 'Orders'. This may take a while to complete.
6.20 14:13:12: DEMOSERVER\GenOdbc2Mxf: 5275 0 Getting approximate row count for table 'Organization'. This may take a while to complete.
6.20 14:13:12: DEMOSERVER\GenOdbc2Mxf: 5275 0 Getting approximate row count for table 'Products'. This may take a while to complete.
6.20 14:13:12: DEMOSERVER\GenOdbc2Mxf: 5275 0 Getting approximate row count for table 'Shippers'. This may take a while to complete.
6.20 14:13:12: DEMOSERVER\GenOdbc2Mxf: 5275 0 Getting approximate row count for table 'Suppliers'. This may take a while to complete.
6.20 14:13:12: DEMOSERVER\GenOdbc2Mxf: 5275 0 Getting approximate row count for table 'Territories'. This may take a while to complete.
6.20 14:13:12: DEMOSERVER\GenOdbc2Mxf: 5076 0 Primary key definition is not available for table 'Categories'.
6.20 14:13:12: DEMOSERVER\GenOdbc2Mxf: 5076 0 Primary key definition is not available for table 'Cust_Info'.
6.20 14:13:12: DEMOSERVER\GenOdbc2Mxf: 5076 0 Primary key definition is not available for table 'Division'.
6.20 14:13:12: DEMOSERVER\GenOdbc2Mxf: 5076 0 Primary key definition is not available for table 'Employees'.
6.20 14:13:12: DEMOSERVER\GenOdbc2Mxf: 5076 0 Primary key definition is not available for table 'EmployeeTerritories'.
6.20 14:13:12: DEMOSERVER\GenOdbc2Mxf: 5076 0 Primary key definition is not available for table 'OrderDetails'.
6.20 14:13:12: DEMOSERVER\GenOdbc2Mxf: 5076 0 Primary key definition is not available for table 'Orders'.
6.20 14:13:12: DEMOSERVER\GenOdbc2Mxf: 5076 0 Primary key definition is not available for table 'Organization'.
6.20 14:13:13: DEMOSERVER\GenOdbc2Mxf: 5076 0 Primary key definition is not available for table 'Products'.
6.20 14:13:13: DEMOSERVER\GenOdbc2Mxf: 5076 0 Primary key definition is not available for table 'Shippers'.
6.20 14:13:13: DEMOSERVER\GenOdbc2Mxf: 5076 0 Primary key definition is not available for table 'Suppliers'.
6.20 14:13:13: DEMOSERVER\GenOdbc2Mxf: 5076 0 Primary key definition is not available for table 'Territories'.
6.20 14:13:13: DEMOSERVER\GenOdbc2Mxf: 24 0 Source database meta data extracted. Starting PSDB load.
6.20 14:13:13: DEMOSERVER\GenOdbc2Mxf: 7 0 Unable to continue. Contact technical support.
6.20 14:13:13: Meta Data Loader Done.
Process halted due to problem(s).
When I used the IBM DB2 ODBC driver for connection to the repository in the Connection manager instead of the "Ascential" one, this test passes, but problem moves to the phase when I want to load DataBase Meta Data (I see in the log window I'm able to read data but I'm not able to load them into repository):
6.20 14:13:10: DEMOSERVER\GenOdbc2Mxf: 5039 0 Program GenOdbc2Mxf running. Computer: DEMOSERVER. Process ID: 400. Program ID: 6.
6.20 14:13:12: DEMOSERVER\GenOdbc2Mxf: 23 0 Program initialization is now complete.
6.20 14:13:12: DEMOSERVER\GenOdbc2Mxf: 5275 0 Getting approximate row count for table 'Categories'. This may take a while to complete.
6.20 14:13:12: DEMOSERVER\GenOdbc2Mxf: 5275 0 Getting approximate row count for table 'Cust_Info'. This may take a while to complete.
6.20 14:13:12: DEMOSERVER\GenOdbc2Mxf: 5275 0 Getting approximate row count for table 'Division'. This may take a while to complete.
6.20 14:13:12: DEMOSERVER\GenOdbc2Mxf: 5275 0 Getting approximate row count for table 'Employees'. This may take a while to complete.
6.20 14:13:12: DEMOSERVER\GenOdbc2Mxf: 5275 0 Getting approximate row count for table 'EmployeeTerritories'. This may take a while to complete.
6.20 14:13:12: DEMOSERVER\GenOdbc2Mxf: 5275 0 Getting approximate row count for table 'OrderDetails'. This may take a while to complete.
6.20 14:13:12: DEMOSERVER\GenOdbc2Mxf: 5275 0 Getting approximate row count for table 'Orders'. This may take a while to complete.
6.20 14:13:12: DEMOSERVER\GenOdbc2Mxf: 5275 0 Getting approximate row count for table 'Organization'. This may take a while to complete.
6.20 14:13:12: DEMOSERVER\GenOdbc2Mxf: 5275 0 Getting approximate row count for table 'Products'. This may take a while to complete.
6.20 14:13:12: DEMOSERVER\GenOdbc2Mxf: 5275 0 Getting approximate row count for table 'Shippers'. This may take a while to complete.
6.20 14:13:12: DEMOSERVER\GenOdbc2Mxf: 5275 0 Getting approximate row count for table 'Suppliers'. This may take a while to complete.
6.20 14:13:12: DEMOSERVER\GenOdbc2Mxf: 5275 0 Getting approximate row count for table 'Territories'. This may take a while to complete.
6.20 14:13:12: DEMOSERVER\GenOdbc2Mxf: 5076 0 Primary key definition is not available for table 'Categories'.
6.20 14:13:12: DEMOSERVER\GenOdbc2Mxf: 5076 0 Primary key definition is not available for table 'Cust_Info'.
6.20 14:13:12: DEMOSERVER\GenOdbc2Mxf: 5076 0 Primary key definition is not available for table 'Division'.
6.20 14:13:12: DEMOSERVER\GenOdbc2Mxf: 5076 0 Primary key definition is not available for table 'Employees'.
6.20 14:13:12: DEMOSERVER\GenOdbc2Mxf: 5076 0 Primary key definition is not available for table 'EmployeeTerritories'.
6.20 14:13:12: DEMOSERVER\GenOdbc2Mxf: 5076 0 Primary key definition is not available for table 'OrderDetails'.
6.20 14:13:12: DEMOSERVER\GenOdbc2Mxf: 5076 0 Primary key definition is not available for table 'Orders'.
6.20 14:13:12: DEMOSERVER\GenOdbc2Mxf: 5076 0 Primary key definition is not available for table 'Organization'.
6.20 14:13:13: DEMOSERVER\GenOdbc2Mxf: 5076 0 Primary key definition is not available for table 'Products'.
6.20 14:13:13: DEMOSERVER\GenOdbc2Mxf: 5076 0 Primary key definition is not available for table 'Shippers'.
6.20 14:13:13: DEMOSERVER\GenOdbc2Mxf: 5076 0 Primary key definition is not available for table 'Suppliers'.
6.20 14:13:13: DEMOSERVER\GenOdbc2Mxf: 5076 0 Primary key definition is not available for table 'Territories'.
6.20 14:13:13: DEMOSERVER\GenOdbc2Mxf: 24 0 Source database meta data extracted. Starting PSDB load.
6.20 14:13:13: DEMOSERVER\GenOdbc2Mxf: 7 0 Unable to continue. Contact technical support.
6.20 14:13:13: Meta Data Loader Done.
Process halted due to problem(s).
I don't know what could be happening here. Does your UserID or Password contain `special' characters that might be causing problems in Profilestage. The import metadata looks like it might be hitting a table permissions/authority issue.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
All of those messages appeared within at most 1.5 seconds. So it does not appear that the problem is entirely within ProfileStage. Can you use the test utility for the ODBC driver to determine that you can connect successfully and get a list of tables? Can you try to import the ODBC table definitions using DataStage, and see whether the same error occurs?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.