Question
Ford Motor Company
US
Last activity: 11 Jan 2019 9:43 EST
Getting exception while creating Segment
Hi Team,
We are getting the below exception while creating a Segment, we are using Pega 7.3.1 and Pega Marketing 7.31 with SQL 2016.
Hi Team,
We are getting the below exception while creating a Segment, we are using Pega 7.3.1 and Pega Marketing 7.31 with SQL 2016.
2018-08-31 10:04:23,950 [ TP_http : 122] [TABTHREAD4] [ ] [ EdisonNBA:01.01.01] (port_Definition_Segment.Action) ERROR wwwdev.pega-pd.ici.ford.com|xx.xx.xx.xx xfeng10 - CreateSegmentTable - Exception while creating the segment table: com.microsoft.sqlserver.jdbc.SQLServerException: Unknown object type 'UNLOGGED' used in a CREATE, DROP, or ALTER statement. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216) ~[sqljdbc4.jar:?] at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515) ~[sqljdbc4.jar:?] at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:792) ~[sqljdbc4.jar:?] at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:689) ~[sqljdbc4.jar:?] at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696) ~[sqljdbc4.jar:?] at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715) ~[sqljdbc4.jar:?] at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180) ~[sqljdbc4.jar:?] at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155) ~[sqljdbc4.jar:?] at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeUpdate(SQLServerStatement.java:642) ~[sqljdbc4.jar:?] at com.pegarules.generated.activity.ra_action_createsegmenttable_58a57ec08ef25966d3211089b322d384.step2_circum0(ra_action_createsegmenttable_58a57ec08ef25966d3211089b322d384.java:302) ~[?:?] at com.pegarules.generated.activity.ra_action_createsegmenttable_58a57ec08ef25966d3211089b322d384.perform(ra_action_createsegmenttable_58a57ec08ef25966d3211089b322d384.java:87) ~[?:?] at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3597) ~[prprivate.jar:?] at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:10845) ~[prprivate.jar:?] at com.pegarules.generated.activity.ra_action_pypostsave_6e80d4955216cf724bfc13c0d73db276.step17_circum0(ra_action_pypostsave_6e80d4955216cf724bfc13c0d73db276.java:1990) ~[?:?] at com.pegarules.generated.activity.ra_action_pypostsave_6e80d4955216cf724bfc13c0d73db276.perform(ra_action_pypostsave_6e80d4955216cf724bfc13c0d73db276.java:379) ~[?:?] at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3597) ~[prprivate.jar:?] at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:10845) ~[prprivate.jar:?] at com.pegarules.generated.activity.ra_action_save_10424520e82337ffce9ded71444b1a12.step26_circum0(ra_action_save_10424520e82337ffce9ded71444b1a12.java:2366) ~[?:?] at com.pegarules.generated.activity.ra_action_save_10424520e82337ffce9ded71444b1a12.perform(ra_action_save_10424520e82337ffce9ded71444b1a12.java:556) ~[?:?] at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3597) ~[prprivate.jar:?] at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:10845) ~[prprivate.jar:?] at com.pegarules.generated.activity.ra_action_wbsave_f4476f734a9fffad799118a95aed5830.step5_circum0(ra_action_wbsave_f4476f734a9fffad799118a95aed5830.java:755) ~[?:?] at com.pegarules.generated.activity.ra_action_wbsave_f4476f734a9fffad799118a95aed5830.perform(ra_action_wbsave_f4476f734a9fffad799118a95aed5830.java:141) ~[?:?]
***Edited by Moderator Marissa to update platform capability tags****
Pegasystems Inc.
FR
Hello Anandh,
I think I managed to confuse myself here. I guess I wrongly post this question by mistake. Very sorry about this.
I was looking into your stack and it might be an SQL Server specific issue as the class failing isn't a Pega one:
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)
Have you tried to work with your DBA to identify which SQL query is actually failing? If you do not have available DBA do you mind tracing this action and sharing tracer output.
Ford Motor Company
US
Hi Marc,
I see Pega trying to create a table with unsupported column by SQL.
com.microsoft.sqlserver.jdbc.SQLServerException: Unknown object type 'UNLOGGED' used in a CREATE, DROP, or ALTER statement.
Regards,
Anandh
Pegasystems Inc.
US
Hi Anandh,
We are hoping you got past this problem now. It looks like your DB type in the configuration (application system settings of Pega Marketing) is som how still set to Postgres, and thats the reason you are seeing this. You can try re-saving the application settings and see if the segment creation is fine.
Pegasystems Inc.
US
Hi, This is not a UI setting, once you edit and save the landing page under : Configuration-->Settings-->Application Settings in the Pega Marketing portal (with Marketing Administrator role ) , the value is automatically updated based on the DB type you are connecting to. You can verify if you have the right value by opening the clipboard and navigating to Standard(thread)-->Data Pages--> Declare_MKTSystemSetting and the property named DBType should hold the value for the right DB type.