Question

1
Replies
66
Views
Close popover
Amulya Bojja (AmulyaB3)
Incessant Technologies PVT Ltd

Incessant Technologies PVT Ltd
IN
AmulyaB3 Member since 2018 1 post
Incessant Technologies PVT Ltd
Posted: June 20, 2019
Last activity: June 28, 2019
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,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.