Hi, I am getting the following error while executing a query through

Sumeet Khare over 10 years ago

Hi,

I am getting the following error while executing a query through Query Node. Error is:

2013-10-15 23:06:16,066 [http-0.0.0.0-8080-13] ERROR com.appiancorp.process.runtime.activities.QueryRdbmsActivity - Unable to convert to expected Date/Time Java types
java.lang.NullPointerException
          at com.appiancorp.process.runtime.activities.QueryRdbmsActivity.toExpectedDateTimeType(QueryRdbmsActivity.java:528)
          at com.appiancorp.process.runtime.activities.QueryRdbmsActivity.executeQueries(QueryRdbmsActivity.java:397)
          at com.appiancorp.process.runtime.activities.QueryRdbmsActivity.execute(QueryRdbmsActivity.java:98)

the result set of the query does not include date or date Time object but still I am getting the error,

Any idea why am I getting it?...

Discussion posts and replies are publicly visible

0 Eduardo Fuentes
Appian Employee
over 10 years ago

When using the Query RDBMS activity to retrieve date/time columns, if the column contains null's the following error is displayed in the application server log:

15:55:51,275 INFO [STDOUT] 2011-11-29 15:55:51,274 [WorkManager(2)-21] ERROR com.appiancorp.process.runtime.activities.QueryRdbmsActivity - Unable to convert to expected Date/Time Java types
java.lang.NullPointerException
at com.appiancorp.process.runtime.activities.QueryRdbmsActivity.toExpectedDateTimeType(QueryRdbmsActivity.java:528)
.....

The process completes fine, but the error makes the user think there's a problem. The message is informative and can be disregarded.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Sumeet Khare over 10 years ago

Hi Eduardo,

the query which I am firing does not include any date or date Time columns and the result set is just one column having number type. This issue is observed only in one environment and not on others. All the environments are on Appian 6.6.1
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Eduardo Fuentes
Appian Employee
over 10 years ago

Then probably this error is not coming from your query but from another process that just happened to run at the same time as yours.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Sumeet Khare over 10 years ago

thanks for your info..
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel