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.
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 [email protected] - 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.