Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Richard Zuurveld (Richard_Z)
Rabobank
Pega Lead System Architect
Rabobank
NL
Richard_Z Member since 2014 3 posts
Rabobank
Posted: Apr 10, 2017
Last activity: Aug 1, 2017
Posted: 10 Apr 2017 7:21 EDT
Last activity: 1 Aug 2017 17:30 EDT
Closed
Solved

Problem invoking function: pega_importexport_pximportexport.pxHasSchemaChanges--(Boolean), The argument did not contain a SELECT token.

Our enviroment has just been upgraded from Pega version 7.1.8 to 7.2.2., after which I have an issue importing a package.

The package contains a connection to a MS SQL DB, which is already present on the environment I am trying to import it on. Actually, the same package has been imported to this environment before, in version 7.1.8.

After selecting the right file in the Import Wizard and clicking Next, the following error is shown:

  • The Flow Action post-processing activity pxSetShowAllSteps failed: Problem invoking function: pega_importexport_pximportexport.pxHasSchemaChanges--(Boolean), The argument did not contain a SELECT token.

Further investigation shows that Pega sends this query to that SQL DB:

It tries to execute a stored procedure using a select operation, which results in the error.

Does anyone else have this problem and if so, have a solution?

Show More

Our enviroment has just been upgraded from Pega version 7.1.8 to 7.2.2., after which I have an issue importing a package.

The package contains a connection to a MS SQL DB, which is already present on the environment I am trying to import it on. Actually, the same package has been imported to this environment before, in version 7.1.8.

After selecting the right file in the Import Wizard and clicking Next, the following error is shown:

  • The Flow Action post-processing activity pxSetShowAllSteps failed: Problem invoking function: pega_importexport_pximportexport.pxHasSchemaChanges--(Boolean), The argument did not contain a SELECT token.

Further investigation shows that Pega sends this query to that SQL DB:

It tries to execute a stored procedure using a select operation, which results in the error.

Does anyone else have this problem and if so, have a solution?

DB Trace
Database Name Test
Table Name Test
SQL Operation select
SQL {call sp_helptext(?)}
SQL Inserts <Test>

[MSG][Exception][STACK][com.pega.pegarules.pub.runtime.LibraryFunctionNotFoundException: Problem invoking function: pega_importexport_pximportexport.pxHasSchemaChanges--(Boolean), The argument did not contain a SELECT token. at com.pega.pegarules.generation.internal.library.LibraryRuntime.resolveAndinvokeFunctionViaReflection(LibraryRuntime.java:246) at com.pega.pegarules.generation.internal.library.LibraryRuntime.invokeLibraryRuntime(LibraryRuntime.java:119) at com.pega.pegarules.session.internal.mgmt.Executable.invokeLibraryRuntime(Executable.java:9105) at com.pega.pegarules.priv.generator.LibrarySupport.resolveAndInvokeFunctionViaReflection(LibrarySupport.java:258) at com.pegarules.generated.pega_importexport_pximportexport.pxHasSchemaChanges(pega_importexport_pximportexport.java:342) at com.pegarules.generated.pxHasSchemaChanges_071017_Rm023mqcn95hL8_DJe7q6g.pxHasSchemaChanges07_10_17(pxHasSchemaChanges_071017_Rm023mqcn95hL8_DJe7q6g.java:100) at com.pegarules.generated.pxHasSchemaChanges_071017_Rm023mqcn95hL8_DJe7q6g.invoke(pxHasSchemaChanges_071017_Rm023mqcn95hL8_DJe7q6g.java:82) at com.pega.pegarules.generation.internal.library.LibraryRuntime.resolveAndinvokeFunctionViaReflection(LibraryRuntime.java:221) at com.pega.pegarules.generation.internal.library.LibraryRuntime.invokeLibraryRuntime(LibraryRuntime.java:119) at com.pega.pegarules.session.internal.mgmt.Executable.invokeLibraryRuntime(Executable.java:9105) at com.pega.pegarules.priv.generator.LibrarySupport.resolveAndInvokeFunctionViaReflectionWithException(LibrarySupport.java:275) at com.pegarules.generated.activity.ra_action_pxcontainsschemaarchive_5ca833663034c86fb207c2b1ae4eea65.step1_circum0(ra_action_pxcontainsschemaarchive_5ca833663034c86fb207c2b1ae4eea65.java:183) at com.pegarules.generated.activity.ra_action_pxcontainsschemaarchive_5ca833663034c86fb207c2b1ae4eea65.perform(ra_action_pxcontainsschemaarchive_5ca833663034c86fb207c2b1ae4eea65.java:70) at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3553) at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:10711) at com.pegarules.generated.activity.ra_action_pxsetshowallsteps_c91b43539aa22807661e90fa53ee8440.step2_circum0(ra_action_pxsetshowallsteps_c91b43539aa22807661e90fa53ee8440.java:316) at com.pegarules.generated.activity.ra_action_pxsetshowallsteps_c91b43539aa22807661e90fa53ee8440.perform(ra_action_pxsetshowallsteps_c91b43539aa22807661e90fa53ee8440.java:93) at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3553) at com.pegarules.generated.callActivity_071027_yoB3RheCwDdLlLDKhZ4s2w.callActivity07_10_27(callActivity_071027_yoB3RheCwDdLlLDKhZ4s2w.java:133) at

Show Less
To see attachments, please log in.
Installation and Deployment

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice