Page 1 of 1
Attempt to establish connection failed with security - DB2
Posted: Mon Jun 26, 2006 2:29 am
by akrzy
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
Posted: Mon Jun 26, 2006 3:04 am
by ArndW
Have you been able to connect to that DB/2 instance from the command line with the same userid and password?
Posted: Mon Jun 26, 2006 3:06 am
by akrzy
Yes, I can...
Posted: Mon Jun 26, 2006 3:07 am
by akrzy
Yes, I can...
Posted: Mon Jun 26, 2006 3:07 am
by akrzy
Yes, I can...
Posted: Mon Jun 26, 2006 3:08 am
by akrzy
Sorry, for above 3 answers
I have problem with network
Posted: Mon Jun 26, 2006 3:12 am
by akrzy
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).
Posted: Mon Jun 26, 2006 3:16 am
by ArndW
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.
Posted: Mon Jun 26, 2006 6:03 am
by ray.wurlod
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?
Posted: Mon Jun 26, 2006 6:23 am
by akrzy
Thank you for reply,
But I am not Premium Memeber yet and I can't see you answer...
