Hi All, Besides what I mentioned below, if I try to run Ofbiz and try to login as admin/ofbiz, I get the following message ‘You can’t login to this application’ and these messages in the log. I feel that’s because some admin data is missing, but as I mentioned earlier even if I drop the DB and re-create it keeps giving duplicate PK errors. Appreciate any help, please.
Regards, Emad. 2022-05-09 22:43:01,855 |jsse-nio-8443-exec-9 |ControlServlet |T| [[[login(Domain:https://localhost)] Request Begun, encoding=[UTF-8]- total:0.0,since last(Begin):0.0]] 2022-05-09 22:43:01,888 |jsse-nio-8443-exec-9 |ConfigXMLReader |I| controller loaded: 0.001s, 16 requests, 14 views in file:/C:/apache-ofbiz-18/plugins/birt/webapp/ordermgr/WEB-INF/controller.xml 2022-05-09 22:43:01,939 |jsse-nio-8443-exec-9 |ConfigXMLReader |I| controller loaded: 0.007s, 366 requests, 147 views in file:/C:/apache-ofbiz-18/applications/order/webapp/ordermgr/WEB-INF/controller.xml 2022-05-09 22:43:01,972 |jsse-nio-8443-exec-9 |ConfigXMLReader |I| controller loaded: 0.001s, 49 requests, 21 views in file:/C:/apache-ofbiz-18/framework/common/webcommon/WEB-INF/common-controller.xml 2022-05-09 22:43:02,009 |jsse-nio-8443-exec-9 |ConfigXMLReader |I| controller loaded: 0.0s, 0 requests, 0 views in file:/C:/apache-ofbiz-18/framework/common/webcommon/WEB-INF/handlers-controller.xml 2022-05-09 22:43:02,040 |jsse-nio-8443-exec-9 |ConfigXMLReader |I| controller loaded: 0.0s, 4 requests, 0 views in file:/C:/apache-ofbiz-18/applications/commonext/webapp/WEB-INF/controller.xml 2022-05-09 22:43:02,082 |jsse-nio-8443-exec-9 |ConfigXMLReader |I| controller loaded: 0.006s, 379 requests, 154 views in file:/C:/apache-ofbiz-18/applications/content/webapp/content/WEB-INF/controller.xml 2022-05-09 22:43:02,083 |jsse-nio-8443-exec-9 |JWTManager |I| Internal single sign on is disabled. 2022-05-09 22:43:02,088 |jsse-nio-8443-exec-9 |LoginWorker |I| Setting default delegator 2022-05-09 22:43:02,099 |jsse-nio-8443-exec-9 |ServiceDispatcher |T| Sync service [order/userLogin] finished in [11] milliseconds 2022-05-09 22:43:02,099 |jsse-nio-8443-exec-9 |VisitHandler |I| Found visitorId [10000] in cookie 2022-05-09 22:43:02,107 |jsse-nio-8443-exec-9 |ServiceDispatcher |T| Sync service [order/preferenceGetSetPermission] finished in [1] milliseconds 2022-05-09 22:43:02,111 |jsse-nio-8443-exec-9 |ServiceDispatcher |T| Sync service [order/setUserPreference] finished in [6] milliseconds 2022-05-09 22:43:02,115 |jsse-nio-8443-exec-9 |RequestHandler |I| Ran Event [java:org.apache.ofbiz.webapp.control.LoginWorker#login] from [request], result is [error] 2022-05-09 22:43:02,115 |jsse-nio-8443-exec-9 |RequestHandler |E| Request login caused an error with the following message: You cannot login to this application 2022-05-09 22:43:02,115 |jsse-nio-8443-exec-9 |RequestHandler |I| Rendering View [login]. Hidden sessionId by default. 2022-05-09 22:43:02,120 |jsse-nio-8443-exec-9 |ServiceDispatcher |T| Sync service [order/getUserPreferenceGroup] finished in [3] milliseconds 2022-05-09 22:43:02,142 |jsse-nio-8443-exec-9 |ScreenFactory |I| Got 26 screens in 0.018s from: file:/C:/apache-ofbiz-18/framework/common/widget/CommonScreens.xml 2022-05-09 22:43:02,274 |jsse-nio-8443-exec-9 |ScreenFactory |I| Got 25 screens in 0.017s from: file:/C:/apache-ofbiz-18/themes/common-theme/widget/CommonScreens.xml 2022-05-09 22:43:02,290 |jsse-nio-8443-exec-9 |ScreenFactory |I| Got 4 screens in 0.015s from: file:/C:/apache-ofbiz-18/applications/order/widget/ordermgr/CommonScreens.xml 2022-05-09 22:43:02,302 |jsse-nio-8443-exec-9 |ScreenFactory |I| Got 1 screens in 0.01s from: file:/C:/apache-ofbiz-18/applications/commonext/widget/CommonScreens.xml 2022-05-09 22:43:02,305 |jsse-nio-8443-exec-9 |PrimaryKeyFinder |I| Returning null because found incomplete primary key in find: [GenericEntity:PartyNameView][partyId,null()] 2022-05-09 22:43:02,373 |jsse-nio-8443-exec-9 |ServiceDispatcher |T| Sync service [order/getLastSystemInfoNote] finished in [17] milliseconds 2022-05-09 22:43:02,527 |jsse-nio-8443-exec-9 |ServerHitBin |I| Visit delegatorName=default, ServerHitBin delegatorName=default 2022-05-09 22:43:02,648 |jsse-nio-8443-exec-9 |ControlServlet |T| [[[login(Domain:https://localhost)] Request Done- total:0.793,since last([login(Domain:htt...):0.793]] 2022-05-09 22:43:02,858 |jsse-nio-8443-exec-8 |ControlServlet |T| [[[SetTimeZoneFromBrowser(Domain:https://localhost)] Request Begun, encoding=[UTF-8]- total:0.0,since last(Begin):0.0]] 2022-05-09 22:43:02,864 |jsse-nio-8443-exec-8 |JWTManager |I| Internal single sign on is disabled. 2022-05-09 22:43:02,869 |jsse-nio-8443-exec-8 |ServiceDispatcher |T| [[Sync service failed...- total:0.0,since last(Begin):0.0]] - 'order / SetTimeZoneFromBrowser' 2022-05-09 22:43:02,869 |jsse-nio-8443-exec-8 |TransactionUtil |I| Transaction rolled back 2022-05-09 22:43:02,870 |jsse-nio-8443-exec-8 |TransactionUtil |W| Not committing transaction, status is No Transaction (6) 2022-05-09 22:43:02,870 |jsse-nio-8443-exec-8 |RequestHandler |I| Ran Event [service:#SetTimeZoneFromBrowser] from [request], result is [error] 2022-05-09 22:43:02,870 |jsse-nio-8443-exec-8 |RequestHandler |E| Request SetTimeZoneFromBrowser caused an error with the following message: User authorization is required for this service: SetTimeZoneFromBrowser 2022-05-09 22:43:02,870 |jsse-nio-8443-exec-8 |RequestHandler |I| [RequestHandler.doRequest]: Response is a chained request. Hidden sessionId by default. 2022-05-09 22:43:02,871 |jsse-nio-8443-exec-8 |RequestHandler |I| [RequestHandler]: Chain in place: requestUri=json overrideViewUri=null Hidden sessionId by default. 2022-05-09 22:43:02,872 |jsse-nio-8443-exec-8 |RequestHandler |I| Ran Event [java:org.apache.ofbiz.common.CommonEvents#jsonResponseFromRequestAttributes] from [request], result is [success] 2022-05-09 22:43:02,879 |jsse-nio-8443-exec-8 |ServerHitBin |I| Visit delegatorName=default, ServerHitBin delegatorName=default 2022-05-09 22:43:02,884 |jsse-nio-8443-exec-8 |ControlServlet |T| [[[SetTimeZoneFromBrowser(Domain:https://localhost)] Request Done- total:0.026,since last([SetTimeZoneFromB...):0.026]] > On 8 May 2022, at 12:58 AM, Emad Radwan <[email protected]> wrote: > > Hello Community, > > After struggle configuring Ofbiz to build against SQL Server I have problem > loading seed data and logging as > admin/ofbiz > > I tried a number of grade/gradlew commands to build/load data and the latest > was ‘gradlew cleanall loadall’ > > Part of the messages I get is related to primary key failure due to trying to > insert a duplicate value although I dropped the database and re-created it > before starting the new build. > > Here’s part of the exit messages, if you can help, please. > > Regards, > Emad > > > Caused by: org.apache.ofbiz.entity.GenericEntityException: Error while > inserting: [GenericEntity:Person][createdStamp,2022-05-08 > 00:43:57.619(java.sql.Timestamp)][createdTxStamp,2022-05-08 > 00:43:57.618(java.sql.Timestamp)][lastUpdatedStamp,2022-05-08 > 00:43:57.619(java.sql.Timestamp)][lastUpdatedTxStamp,2022-05-08 > 00:43:57.618(java.sql.Timestamp)][partyId,_NA_(java.lang.String)] (SQL > Exception while executing the following:INSERT INTO dbo.PERSON (PARTY_ID, > SALUTATION, FIRST_NAME, MIDDLE_NAME, LAST_NAME, PERSONAL_TITLE, SUFFIX, > NICKNAME, FIRST_NAME_LOCAL, MIDDLE_NAME_LOCAL, LAST_NAME_LOCAL, OTHER_LOCAL, > MEMBER_ID, GENDER, BIRTH_DATE, DECEASED_DATE, HEIGHT, WEIGHT, > MOTHERS_MAIDEN_NAME, MARITAL_STATUS, SOCIAL_SECURITY_NUMBER, PASSPORT_NUMBER, > PASSPORT_EXPIRE_DATE, TOTAL_YEARS_WORK_EXPERIENCE, COMMENTS, > EMPLOYMENT_STATUS_ENUM_ID, RESIDENCE_STATUS_ENUM_ID, OCCUPATION, > YEARS_WITH_EMPLOYER, MONTHS_WITH_EMPLOYER, EXISTING_CUSTOMER, CARD_ID, > LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) > VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, > ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Cannot insert duplicate key row in > object 'dbo.PERSON' with unique index 'CARD_ID_IDX'. The duplicate key value > is (<NULL>).)) > at > org.apache.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:172) > at > org.apache.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:110) > at > org.apache.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:66) > at > org.apache.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:874) > ... 14 more > Caused by: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception > while executing the following:INSERT INTO dbo.PERSON (PARTY_ID, SALUTATION, > FIRST_NAME, MIDDLE_NAME, LAST_NAME, PERSONAL_TITLE, SUFFIX, NICKNAME, > FIRST_NAME_LOCAL, MIDDLE_NAME_LOCAL, LAST_NAME_LOCAL, OTHER_LOCAL, MEMBER_ID, > GENDER, BIRTH_DATE, DECEASED_DATE, HEIGHT, WEIGHT, MOTHERS_MAIDEN_NAME, > MARITAL_STATUS, SOCIAL_SECURITY_NUMBER, PASSPORT_NUMBER, > PASSPORT_EXPIRE_DATE, TOTAL_YEARS_WORK_EXPERIENCE, COMMENTS, > EMPLOYMENT_STATUS_ENUM_ID, RESIDENCE_STATUS_ENUM_ID, OCCUPATION, > YEARS_WITH_EMPLOYER, MONTHS_WITH_EMPLOYER, EXISTING_CUSTOMER, CARD_ID, > LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) > VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, > ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Cannot insert duplicate key row in > object 'dbo.PERSON' with unique index 'CARD_ID_IDX'. The duplicate key value > is (<NULL>).) > at > org.apache.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:435) > at > org.apache.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:167) > ... 17 more > Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Cannot insert > duplicate key row in object 'dbo.PERSON' with unique index 'CARD_ID_IDX'. The > duplicate key value is (<NULL>). > at > com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:265) > at > com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1676) > at > com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:615) > at > com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:537) > at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7785) > at > com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:3793) > at > com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:268) > at > com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:242) > at > com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(SQLServerPreparedStatement.java:483) > at > org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:136) > at > org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:136) > at > org.apache.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:431) > ... 18 more > >> Task :ofbiz --load-data FAILED > > FAILURE: Build failed with an exception. > > * What went wrong: > Execution failed for task ':ofbiz --load-data'. >> Process 'command 'C:\Program Files\Eclipse >> Adoptium\jdk-8.0.322.6-hotspot\bin\java.exe'' finished with non-zero exit >> value 1 > > * Try: > Run with --stacktrace option to get the stack trace. Run with --info or > --debug option to get more log output. Run with --scan to get full insights. > > * Get more help at https://help.gradle.org > > Deprecated Gradle features were used in this build, making it incompatible > with Gradle 7.0. > Use '--warning-mode all' to show the individual deprecation warnings. > See > https://docs.gradle.org/6.5/userguide/command_line_interface.html#sec:command_line_warnings > > BUILD FAILED in 2m 36s > 25 actionable tasks: 21 executed, 4 up-t
