Support Article

Problem when importing package into Pega 7.2.2

SA-37171

Summary



The user is trying to import a package in their new Pega 7.2.2 system. The package contains a connection to a MS SQL Database, which is already present on the environment.
After selecting the right file in the Import Wizard and clicking Next, the following error is shown on screen:


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.

Error Messages



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

at com.pega.pegarules.deploy.external.util.ViewSubstitutionUtils.stripCreateViewSyntax(ViewSubstitutionUtils.java:192)
at com.pega.pegarules.data.internal.ddlcomp.ObjectMetadataExtractor.updateViewTextToUseModelTableNames(ObjectMetadataExtractor.java:159)
at com.pega.pegarules.data.internal.ddlcomp.ObjectMetadataExtractor.updateViewElementContents(ObjectMetadataExtractor.java:87)
at com.pega.pegarules.data.internal.ddlcomp.ObjectMetadataExtractor.extractObjectMetadata(ObjectMetadataExtractor.java:217)
at com.pega.pegarules.data.internal.ddlcomp.ImportDDLGenerator.generateDDL(ImportDDLGenerator.java:141)
at com.pega.pegarules.data.internal.ddlcomp.SchemaChangeUtilityImpl.generateDDL(SchemaChangeUtilityImpl.java:159)
at com.pega.pegarules.deploy.internal.util.SchemaImporterTool.getDDL(SchemaImporterTool.java:705)
at com.pega.pegarules.deploy.internal.util.SchemaImporterTool.getDDL(SchemaImporterTool.java:730)
at com.pega.pegarules.deploy.internal.util.SchemaImporterTool.getDDL(SchemaImporterTool.java:602)
at com.pega.pegarules.deploy.internal.util.SchemaImporterTool.getDDL(SchemaImporterTool.java:597)
at com.pega.pegarules.deploy.internal.util.SchemaImporterTool.getDDL(SchemaImporterTool.java:569)
at com.pega.pegarules.deploy.internal.util.SchemaImporterTool.getDDL(SchemaImporterTool.java:549)
at com.pegarules.generated.pxHasSchemaChanges_071025_0l388gTDHBioTXe_UFyGew.pxHasSchemaChanges07_10_25(pxHasSchemaChanges_071025_0l388gTDHBioTXe_UFyGew.java:172)


Tracer shows the below error :


com.microsoft.sqlserver.jdbc.SQLServerException: There is no text for object '[SchemaName].[TableName]'.

Steps to Reproduce



Install a Pega 7.2.2. system with MS SQL Server as the Database.


Root Cause



The Pega runtime user used to connect to database does not has the permisson to execute Stored Procedures.

Resolution



As per the installation guide of Pega 7.2.2 , the Pega Base user(for a dual user configuration) requires the permission to execute stored procedures for system operations.
And if this is a single runtime user configuration then this user must have all the privileges ( Base + Admin combined).


After giving the admin rights to the user the issue is resolved.

Published April 27, 2017 - Updated April 29, 2017

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.