Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Nagaraj Ponnurangam (NagarajP0101)
ING Belgium SA NV

ING Belgium SA NV
BE
NagarajP0101 Member since 2017 54 posts
ING Belgium SA NV
Posted: Mar 21, 2018
Last activity: Mar 22, 2018
Posted: 21 Mar 2018 17:44 EDT
Last activity: 22 Mar 2018 7:56 EDT
Closed
Solved

Oracle migration issue : NL Exception was generated DSRA0010E: SQL State = 08006, Error Code = 17,002

We recently created new oracle DB setup(of oracle of version12c) in sandbox environment. When we tried restarting the server, could not access the designer studio and could see below error message in systemout file.

java.sql.SQLRecoverableException: IO Error: NL Exception was generated DSRA0010E: SQL State = 08006, Error Code = 17,002

Kindly advise what could be possible error for this.

Please note that we have copied db tables from dev and imported in sandbox environment.

***Updated by moderator: Lochan to update Categories***

To see attachments, please log in.
DevOps
Data Integration

Accepted Solution

Posted: 8 years ago
Posted: 22 Mar 2018 4:15 EDT
Hemanth Inakollu (inakh)
PEGA
Associate Technical Solutions Engineer
Pegasystems Inc.
IN

Hi Nagaraj,

This error might be due to Syntactical errors like double quotes etc.. in Data source tag. Please check the Db connection Parameters for your new Database in "Context.xml" file or where Db URL is specified along with username and password. 

Regards,

Hemanth

To see attachments, please log in.
Posted: 8 years ago
Posted: 22 Mar 2018 7:56 EDT
Nagaraj Ponnurangam (NagarajP0101)
ING Belgium SA NV

ING Belgium SA NV
BE

Thanks for the suggestion. we found that bracket were missing in connection string. Issue is been resolved by correcting brackets

To see attachments, please log in.
Posted: 8 years ago
Posted: 22 Mar 2018 5:20 EDT
Sudhakar Reddy Yaparla (YSudhakarReddy)
JPMorgan Chase & Company

JPMorgan Chase & Company
US

Hi,

Please share complete stack trace to understand the root cause for this issue.

To see attachments, please log in.

Related content:

Question

An I/O error occurred while sending to the backend.  | SQL Code: 0 | SQL State: 08006 

Question Solved

Migrating from Oracle to SQL

Question Solved

Error: An error occured on executing the query for the report definition - There was a problem getting a list: code: 0 SQLState: 08006 Message: An I/O error occurred while sending to the backend. DatabaseException caused by prior exception: org.postgresql.util.PSQLException: An I/O error occurred while sending to the backend. | SQL Code: 0 | SQL State: 08006

Question

Migrating Oracle DB to Microsoft SQL Server.

Question

Migrate Code from Oracle to PostGre database

Question

Oracle to Postgres Migration

Question

Data Migration tool from SQL Server to Oracle.

Question

SQL Code: 208 | SQL State: S0002 after 7.3 upgrade from 7.2.2

Question

SQL server migration to Oracle for the PRPC731.

Question

Migrating Database from Oracle to MS Sql

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice