Question

2
Replies
38
Views
Naveen Bandaru (NaveenK88)
infosys

infosys
NL
NaveenK88 Member since 2020 2 posts
infosys
Posted: February 16, 2021
Last activity: March 8, 2021
Posted: 16 Feb 2021 7:24 EST
Last activity: 8 Mar 2021 20:55 EST

BIX : DATE Type Atrribute Issue in Extraction


I have property which is DATE in Pega ,BIX rule also i have defined it as DATE and Database 
also column type corresponding also DATE.

We are using out put format in BIX as Database. So while running the BIX extraction failed
and only few records processed.

SQL Exception :ORA-01861: De constante komt niet overeen met de notatiestring.

Log Error :

I have property which is DATE in Pega ,BIX rule also i have defined it as DATE and Database 
also column type corresponding also DATE.

We are using out put format in BIX as Database. So while running the BIX extraction failed
and only few records processed.

SQL Exception :ORA-01861: De constante komt niet overeen met de notatiestring.

Log Error :

2021-02-15T14:48:23,975Z [workmanager_PRPC : 4] [                    ] [      IRBix:01.01.01] (   internal.access.ExtractImpl) ALERT  naveen - 2021-02-15 14:48:23,975 GMT*8*EXCP0001*0*0*c7153affe95bf47b46af383655ddb0ad*NA*NA*BNP8PGEB781OW2KH2DHONIO1SRS5C2MRDA*naveen*RBG-IRBix-Work*IRBix:01.01.01*c217600882638e8c82 22a3714a8b0164*Y*1*BNP8PGEB781OW2KH2DHONIO1SRS5C2MRDA*3578*WorkManager.workmanager_PRPC : 4*STANDARD*com.pega.pegarules.data.internal.access.ExtractImpl*NA*Rule-Admin-Extract.runExtract*Rule-Obj-Activity:ApplicationSetup*RULE-ADMIN-EXTRAC T RUNEXTRACT #20180713T143905.595 GMT Step: 1 Circum: 0*NA****NA*NA*NA*NA*NA*NA*java;RULE-OBJ-ACTIVITY RULE-ADMIN-EXTRACT RUNEXTRACT #20180713T143905.595 GMT Step: 1 Circum: 0;doActivity Rule-Obj-Activity:runExtract;initial Executable;0 additional frames in stack;*schemaFile=[removed];pzHarnessID=[removed];purpose=[removed];pyCreateDateTime=[removed];AJAXTrackID=18;pyReturnsResponse=[removed];pzIsEncryp tedActionString=[removed];pzActivityParamsEncrypted=[removed];pzUseCurrentAccessGroupForChild=[removed];pxCreateDateTime=[removed];pzFromFrame=[remo ved];ClassName=[removed];inStandardsMode=true;pzActionID=[removed];rowNumber=[removed];pzActivity=[removed];IDNumber=[removed];pzActivityParams=[rem oved];generateManifestSchema=[removed];pzPrimaryPageName=[removed];zipFileName=[removed];pzTransactionId=[removed];UITemplatingStatus=[removed];pxOb jClass=@baseclass;generateSchema=[removed];manifestSchemaFile=[removed];*[MSG][Severe SQL Exception: ORA-01861: De constante komt niet overeen met de notatiestring.<CR>][STACK][java.sql.BatchUpdateException: ORA-01861: De constante komt niet overeen met de notatiestring.<CR><CR>    at oracle.jdbc.driver.OraclePreparedStatement.executeLargeBatch(OraclePreparedStatement.java:10032)<CR>    at oracle.jdbc.driver.T4CPreparedStatement.executeLargeBatch(T4CPreparedStatement.java:1364)<CR>    at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:9839)<CR>    at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:234)<CR>    at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecuteBatch(WSJdbcPreparedStatement.java:1146)<CR>    at com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.executeBatch(WSJdbcStatement.java:856)<CR>    at com.pega.pegarules.data.internal.store.DatabasePreparedStatementImpl.executeBatch(DatabasePreparedStatementImpl.java:491)<CR>    at com.pega.pegarules.data.internal.access.ExtractImpl.insertRowsBatchMode(ExtractImpl.java:4453)<CR>    at com.pega.pegarules.data.internal.access.ExtractImpl.insertRowsBatchModeForDatabaseType(ExtractImpl.java:5750)<CR>    at com.pega.pegarules.data.internal.access.ExtractImpl.extractData(ExtractImpl.java:2711)<CR>    at com.pega.pegarules.data.internal.access.ExtractImpl.doExtract(ExtractImpl.java:2083)<CR>    at com.pega.pegarules.data.internal.access.ExtractImpl.runExtract(ExtractImpl.java:1296)<CR>    at com.pega.pegarules.data.internal.access.ExtractImpl.run(ExtractImpl.java:1129)<CR>    at com.pega.pegarules.session.internal.PRSessionProviderImpl.performTargetActionWithLock(PRSessionProviderImpl.java:1397)<CR>    at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:1140)<CR>    at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:947)<CR>    at com.pega.pegarules.data.internal.access.ExtractImpl.runEngineExtract(ExtractImpl.java:1112)<CR>    at com.pega.pegarules.data.internal.access.DatabaseImpl.executeExtract(DatabaseImpl.java:3588)<CR>    at com.pega.pegarules.session.internal.mgmt.Executable.executeExtract(Executable.java:8796)<CR>    at com.pegarules.generated.activity.ra_action_runextract_c31b2b8088d1781c0f96f51842fa3c31.step1_circum0(ra_action_runextract_c31b2b8088d1781c0f96f51842 fa3c31.java:176)<CR>    at com.pegarules.generated.activity.ra_action_runextract_c31b2b8088d1781c0f96f51842fa3c31.perform(ra_action_runextract_c31b2b8088d1781c0f96f51842fa3c31 .java:76)<CR>    at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:2814)<CR>    at com.pega.pegarules.session.internal.mgmt.base.ThreadRunner.runActivitiesAlt(ThreadRunner.java:653)<CR>    at com.pega.pegarules.session.internal.mgmt.base.ThreadRunner.runActivities(ThreadRunner.java:580)<CR>    at com.pega.pegarules.session.internal.mgmt.PRThreadImpl.runActivities(PRThreadImpl.java:511)<CR>    at com.pega.pegarules.session.internal.async.agent.QueueProcessor.executeBatchTask(QueueProcessor.java:304)<CR>    at com.pega.pegarules.session.internal.async.agent.QueueProcessor.execute(QueueProcessor.java:360)<CR>    at com.pega.pegarules.session.internal.async.BatchRequestorTask.run(BatchRequestorTask.java:1158)<CR>    at com.pega.pegarules.session.internal.PRSessionProviderImpl.performTargetActionWithLock(PRSessionProviderImpl.java:1397)<CR>    at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:1140)<CR>    at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:1021)<CR>    at com.pega.pegarules.session.internal.async.BatchRequestorTask.run(BatchRequestorTask.java:818)<CR>    at com.pega.pegarules.session.internal.async.Agent.runBatchTask(Agent.java:859)<CR>    at com.pega.pegarules.session.internal.engineinterface.etier.impl.AsyncServant.processAsyncTask(AsyncServant.java:252)<CR>    at com.pega.pegarules.session.internal.engineinterface.etier.impl.AsyncServant.invoke(AsyncServant.java:178)<CR>    at com.pega.pegarules.session.internal.engineinterface.etier.impl.EngineImpl._invokeEngine_privact(EngineImpl.java:338)<CR>    at com.pega.pegarules.session.internal.engineinterface.etier.impl.EngineImpl.invokeEngine(EngineImpl.java:282)<CR>    at com.pega.pegarules.session.internal.engineinterface.etier.ejb.EngineBean.invokeEngine(EngineBean.java:231)<CR>    at sun.reflect.GeneratedMethodAccessor129.invoke(Unknown Source)<CR>    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)<CR>    at java.lang.reflect.Method.invoke(Method.java:508)<CR>    at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:385)<CR>    at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingThrowable(PRBootstrap.java:427)<CR>    at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethodPropagatingThrowable(AppServerBridgeToPega.java:225)<CR>    at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethodPropagatingException(AppServerBridgeToPega.java:247)<CR>    at com.pega.pegarules.internal.etier.ejb.EngineBeanBoot.invokeEngine(EngineBeanBoot.java:173)<CR>    at com.pega.pegarules.internal.etier.interfaces.EJSLocalStatelessEngineBMT_f2439d86.invokeEngine(Unknown Source)<CR>    at com.pega.pegarules.session.internal.engineinterface.etier.mdb.PRAsync.processRequest(PRAsync.java:157)<CR>    at com.pega.pegarules.session.internal.engineinterface.etier.asynchbeans.AsyncTask.run(AsyncTask.java:67)<CR>    at com.pega.pegarules.session.internal.engineinterface.etier.asynchbeans.RunnableWrapper.run(RunnableWrapper.java:88)<CR>    at com.ibm.ws.asynchbeans.J2EEContext$RunProxy.run(J2EEContext.java:271)<CR>    at java.security.AccessController.doPrivileged(AccessController.java:647)<CR>    at com.ibm.ws.asynchbeans.J2EEContext.run(J2EEContext.java:797)<CR>    at com.ibm.ws.asynchbeans.WorkWithExecutionContextImpl.go(WorkWithExecutionContextImpl.java:222)<CR>    at com.ibm.ws.asynchbeans.ABWorkItemImpl.run(ABWorkItemImpl.java:206)<CR>    at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1892)<CR>]*   

***Edited by Moderator Marissa to update Platform Capability tags****
Pega Business Intelligence Exchange 8.4 System Administration Financial Services Lead System Architect