I have created Expression rule with queryEntity() function. It connects with dis

komalk over 8 years ago

I have created Expression rule with queryEntity() function. It connects with distant database, and fetches data.
The rule works fine in dev environment. but it fails in another environment.
I tried publishing datastore for entity: MY_PROJECT_CUST
Rule is:
a!queryEntity(
entity: cons!MY_PROJECT_CUST,
query: a!query(
selection: a!querySelection(
columns: {
a!queryColumn(
field: "CUST_ID"
),
a!queryColumn(
field: "CUST_NME"
)
}
),
pagingInfo: a!pagingInfo(
startIndex: 1,
batchSize: - 1,
sort: a!sortInfo(
field: "CUST_NME",
ascending: true()
)
)
)
).data

I am getting error:Expression evaluation error at function a!queryEntity [line 2]: An error occurred while retrieving the data.

Discussion posts and replies are publicly visible

Parents

0 komalk over 8 years ago

I have checked logs it shows error: 2016-01-05 18:38:31,911 [ajp-/144.226.143.101:8009-3] ERROR org.hibernate.util.JDBCExceptionReporter - ORA-00942: table or view does not exist

2016-01-05 18:38:32,044 [ajp-/144.226.143.101:8009-3] ERROR org.hibernate.util.JDBCExceptionReporter - ORA-00942: table or view does not exist

2016-01-05 18:38:33,038 [ajp-/144.226.143.101:8009-3] ERROR org.hibernate.util.JDBCExceptionReporter - ORA-00942: table or view does not exist

2016-01-05 18:38:33,957 [ajp-/144.226.143.101:8009-3] ERROR org.hibernate.util.JDBCExceptionReporter - ORA-00942: table or view does not exist

2016-01-05 18:38:34,789 [ajp-/144.226.143.101:8009-3] ERROR org.hibernate.util.JDBCExceptionReporter - ORA-00942: table or view does not exist

2016-01-05 18:38:35,559 [ajp-/144.226.143.101:8009-3] ERROR org.hibernate.util.JDBCExceptionReporter - ORA-00942: table or view does not exist

2016-01-05 18:40:02,931 [ajp-/144.226.143.101:8009-3] ERROR org.hibernate.util.JDBCExceptionReporter - ORA-00942: table or view does not exist
Actually table is there n I have also published datastore so
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 komalk over 8 years ago

I have checked logs it shows error: 2016-01-05 18:38:31,911 [ajp-/144.226.143.101:8009-3] ERROR org.hibernate.util.JDBCExceptionReporter - ORA-00942: table or view does not exist

2016-01-05 18:38:32,044 [ajp-/144.226.143.101:8009-3] ERROR org.hibernate.util.JDBCExceptionReporter - ORA-00942: table or view does not exist

2016-01-05 18:38:33,038 [ajp-/144.226.143.101:8009-3] ERROR org.hibernate.util.JDBCExceptionReporter - ORA-00942: table or view does not exist

2016-01-05 18:38:33,957 [ajp-/144.226.143.101:8009-3] ERROR org.hibernate.util.JDBCExceptionReporter - ORA-00942: table or view does not exist

2016-01-05 18:38:34,789 [ajp-/144.226.143.101:8009-3] ERROR org.hibernate.util.JDBCExceptionReporter - ORA-00942: table or view does not exist

2016-01-05 18:38:35,559 [ajp-/144.226.143.101:8009-3] ERROR org.hibernate.util.JDBCExceptionReporter - ORA-00942: table or view does not exist

2016-01-05 18:40:02,931 [ajp-/144.226.143.101:8009-3] ERROR org.hibernate.util.JDBCExceptionReporter - ORA-00942: table or view does not exist
Actually table is there n I have also published datastore so
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data