BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: No events within the next 45 days.

BODS Error 54003


 
Search this topic... | Search DI: Installation, Administration, and Connectivities... | Search Box
Register or Login to Post    Forum Index -> Data Integrator -> DI: Installation, Administration, and Connectivities  Previous TopicPrint TopicNext Topic
Author Message
nikhilbods
Forum Member
Forum Member



Joined: 14 May 2018

Posts: 1



PostPosted: Mon May 14, 2018 1:41 am 
Post subject: BODS Error 54003

Hello Guys,

One of our job is giving an 2 different errors as shown below:
1. |Data flow DF_GTFS_TMP_EXPORT_VJ|Loader Query_TMP_GTFS_EXPORT_VJ
Oracle <ODMPROD> error message for operation <OCITransCommit>: <ORA-03113: end-of-file on communication channel
Process ID: 39595
Session ID: 34 Serial number: 30782
>.
(14.1) 05-13-18 21:24:44 (E) (6156:10816) DBS-070301: |Data flow DF_GTFS_TMP_EXPORT_VJ|Loader Query_TMP_GTFS_EXPORT_VJ
Oracle <ODMPROD> error message for operation <OCITransRollback>:[color=red] <ORA-03114: not connected to ORACLE
>

2. |Session 20F_JOB_GTFS_HANDLER_WEEKLY_GEN|Work flow WF_GTFS_HANDLER_WEEKLY_GEN
Function call <sql ( OSDE, SELECT IAS_OSDE_P.P_JOB_MANAGEMENT.CREATE_JOB_LOG('ERROR',1,'50316','GTFS Export Excpetions with 2
incidence: ;Error occurred when uploading GTFS for contract 2441: Oracle <ODMPROD> error message for operation
<OCITransCommit>: <ORA-03113: end-of-file on communication channel
Process ID: 39595
Session ID: 34 Serial number: 30782
>.;Error occurred when uploading GTFS for contract 2450: SELECT query <WITH D as
(
select CurrDate AS full_date ,to_char( MOD( CurrDate - to_date('1/Jan/1000','dd/mm/yyyy'),7)+1 ) as week_day_num
FROM
(SELECT level n,
-- Calendar start') AS JOB_LOG_ID FROM DUAL ) > failed, due to error <70301>: <Oracle <ODMPROD> error message for operation
<OCIStmtExecute>: <ORA-00907: missing right parenthesis
>.>.
(14.1) 05-13-18 23:27:05 (E) (8244:5380) DBS-070301: |Session 20F_JOB_GTFS_HANDLER_WEEKLY_GEN|Work flow WF_GTFS_HANDLER_WEEKLY_GEN
Oracle <ODMPROD> error message for operation <OCIStmtExecute>: <ORA-00907: missing right parenthesis
>.

What could be the issue.
For the first one, i understand the Oracle DB connection must have broken that's why when i run it manually again it completes successfully. For the second one I cannot identify the reason.
Please suggest
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Data Integrator -> DI: Installation, Administration, and Connectivities  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0295 seconds using 17 queries. (SQL 0.0023 Parse 0.0008 Other 0.0263)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo