R98403 Report Failing to Copy Tables

we have recently upgraded to E900 tools release 8.98.1.0. whenever i try running R98403 XJDE0021, the copy fails. Please find below the errors I am getting in JDE.LOG. Please assist.

1888/4608 WRK:Starting jdeCallObject Mon Jun 21 15:28:16.654000 Jdbodbc.c1340

ODB0000163 - SQLDriverConnect failure. rc=-1

1888/4608 WRK:Starting jdeCallObject Mon Jun 21 15:28:16.654001 Jdbodbc.c1340

ODB0000164 - DBC:00 [28000][18456] [Microsoft][SQL Native Client][SQL Server]Login failed for user 'TESTDTA'.

1888/4608 WRK:Starting jdeCallObject Mon Jun 21 15:28:16.670000 Jdbodbc.c1340

ODB0000164 - DBC:01 [28000][18456] [Microsoft][SQL Native Client][SQL Server]Login failed for user 'TESTDTA'.


1888/4608 WRK:Starting jdeCallObject Mon Jun 21 15:28:16.670001 Jdbodbc.c1350

ODB0000010 - SQLDriverConnect failed. ODBC DSN: JDEENT.

1888/4608 WRK:Starting jdeCallObject Mon Jun 21 15:28:16.670002 Jdb_drvm.c909

JDB9900164 - Failed to connect to JDEENT

1888/4608 WRK:Starting jdeCallObject Mon Jun 21 15:28:16.685000 Jtp_cm.c284

JDB9909003 - Could not init connect.

1888/4608 WRK:Starting jdeCallObject Mon Jun 21 15:28:16.795000 Jtp_tm.c1134

JDB9909100 - Get connect info failed: Transaction ID =

1888/4608 WRK:Starting jdeCallObject Mon Jun 21 15:28:16.795001 Jdb_rq1.c2376

JDB3100013 - Failed to get connectinfo

1888/4608 WRK:Starting jdeCallObject Mon Jun 21 15:28:16.795002 Jdb_exem.c1505

JDB2200004 - Failed to open table

1888/4608 WRK:Starting jdeCallObject Mon Jun 21 15:28:16.810000 tccopy.c556

TCE000007 - CopyTable drop output table failed.

R98403 has the default passwords for standard users (TESTDTA, CRPCTL, etc.) hardcoded and unless you have made the required change to the Deployment Server jde.ini and run the R98403 there you must set the password in the RDBMS back to the default (TESTDTA for the TESTDTA user, etc.)



[ QUOTE ]
we have recently upgraded to E900 tools release 8.98.1.0. whenever i try running R98403 XJDE0021, the copy fails. Please find below the errors I am getting in JDE.LOG. Please assist.

1888/4608 WRK:Starting jdeCallObject Mon Jun 21 15:28:16.654000 Jdbodbc.c1340

ODB0000163 - SQLDriverConnect failure. rc=-1

1888/4608 WRK:Starting jdeCallObject Mon Jun 21 15:28:16.654001 Jdbodbc.c1340

ODB0000164 - DBC:00 [28000][18456] [Microsoft][SQL Native Client][SQL Server]Login failed for user 'TESTDTA'.

1888/4608 WRK:Starting jdeCallObject Mon Jun 21 15:28:16.670000 Jdbodbc.c1340

ODB0000164 - DBC:01 [28000][18456] [Microsoft][SQL Native Client][SQL Server]Login failed for user 'TESTDTA'.


1888/4608 WRK:Starting jdeCallObject Mon Jun 21 15:28:16.670001 Jdbodbc.c1350

ODB0000010 - SQLDriverConnect failed. ODBC DSN: JDEENT.

1888/4608 WRK:Starting jdeCallObject Mon Jun 21 15:28:16.670002 Jdb_drvm.c909

JDB9900164 - Failed to connect to JDEENT

1888/4608 WRK:Starting jdeCallObject Mon Jun 21 15:28:16.685000 Jtp_cm.c284

JDB9909003 - Could not init connect.

1888/4608 WRK:Starting jdeCallObject Mon Jun 21 15:28:16.795000 Jtp_tm.c1134

JDB9909100 - Get connect info failed: Transaction ID =

1888/4608 WRK:Starting jdeCallObject Mon Jun 21 15:28:16.795001 Jdb_rq1.c2376

JDB3100013 - Failed to get connectinfo

1888/4608 WRK:Starting jdeCallObject Mon Jun 21 15:28:16.795002 Jdb_exem.c1505

JDB2200004 - Failed to open table

1888/4608 WRK:Starting jdeCallObject Mon Jun 21 15:28:16.810000 tccopy.c556

TCE000007 - CopyTable drop output table failed.

[/ QUOTE ]

Verify ODBC Enterpiseone SSELOCAL connection to SQL Server Database with user TESTDTA and its password.

Checked it and it is failed. Looks like I have SQL user problem

Hello
SO how was this resolved, seems I have a similar issue on my 8.97.

thank you