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

Sumeet Khare over 11 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

Parents

0 Eduardo Fuentes
Appian Employee
over 11 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

Reply

0 Eduardo Fuentes
Appian Employee
over 11 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

Children

No Data