Question

1
Replies
66
Views
AmulyaB3 Member since 2018 1 post
Incessant Technologies PVT Ltd
Posted: 1 year ago
Last activity: 1 year 3 months ago
Closed

Issue with Pega Analytics Director

Hi team,

We have installed PAD on Pega 7.1.7 but are getting an issue when launching the PAD portal.

2019-06-20 19:06:34,434 [http-bio-9106-exec-8] [TABTHREAD0] [                    ] [   DMSample:01.01.01] (      pdm.Util.ExceptionHelper) ERROR 127.0.0.1|127.0.0.1 Admin@HC - Database exception #329: 
 msg="Incorrect syntax near ')'." state="S0001" code=102 
com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near ')'. 
	at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:217) 
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1635) 
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteCursored(SQLServerStatement.java:2094) 
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:839) 
	at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:762) 
	at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:6276) 
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1794) 
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:184) 
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:159) 
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeQuery(SQLServerStatement.java:661) 
	at com.pega.pad.pdm.PersistentStore.BasicSQLDBAgent.retrievePMEntries(BasicSQLDBAgent.java:1598) 
	at com.pega.pad.pdm.ProjectManagement.ProjectManager.updateRootProjectDirectory(ProjectManager.java:331) 
	at com.pega.pad.server.facade.impl.ProjectManagementFacade.getProjectManagementBean(ProjectManagementFacade.java:187) 
	at com.pega.pad.server.facade.PadFacadeImplementation.getProjectManagementBean(PadFacadeImplementation.java:506) 
	at com.pega.pad.connector.ProjectSetupAPI.getProjectList(ProjectSetupAPI.java:753) 
	at com.pegarules.generated.getProjectList_071015_8yh0Nyxm8x1BucP5HvFdVA.getProjectList07_10_15(getProjectList_071015_8yh0Nyxm8x1BucP5HvFdVA.java:144)

Could anyone suggest the issue going behind since we cannot check the SQL generated for the same.

The data table for Data-Decision-IH-* classes are created properly mapped to the PegaDATA schema.

Pega Customer Decision Hub
Moderation Team has archived post
Share this page LinkedIn