Error message when trying to enter 'FIN ACCTS' in Stores

[wp.rauchholz]

I get this massive error  message when triying to add fin accts for a store
The legal entity, GL chart of accounts, etc.. is setup.

Thanks for helping. Wolfgang

2018-06-06 18:40:13,615 |http-nio-8443-exec-1 |RequestHandler |E|
Request CreateProductStoreFinAccountSettings caused an error with the
following message: Error doing entity-auto operation for entity
ProductStoreFinActSetting in service createProductStoreFinActSetting:
org.apache.ofbiz.entity.GenericEntityException:
org.apache.ofbiz.entity.GenericEntityException: Error while inserting:
[GenericEntity:ProductStoreFinActSetting][accountCodeLength,12(java.lang.Long)][accountValidDays,365(java.lang.Long)][allowAuthToNegative,Y(java.lang.String)][authValidDays,5(java.lang.Long)][createdStamp,2018-06-06
18:40:13.609(java.sql.Timestamp)][createdTxStamp,2018-06-06
18:40:13.594(java.sql.Timestamp)][finAccountTypeId,GIFTCERT_ACCOUNT(java.lang.String)][lastUpdatedStamp,2018-06-06
18:40:13.609(java.sql.Timestamp)][lastUpdatedTxStamp,2018-06-06
18:40:13.594(java.sql.Timestamp)][minBalance,null()][pinCodeLength,4(java.lang.Long)][productStoreId,10000(java.lang.String)][purchSurveyCopyMe,copyMe(java.lang.String)][purchSurveySendTo,recipientEmail(java.lang.String)][purchaseSurveyId,1100(java.lang.String)][replenishMethodEnumId,FARP_TOP_OFF(java.lang.String)][replenishThreshold,null()][requirePinCode,N(java.lang.String)][validateGCFinAcct,Y(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO
PRODUCT_STORE_FIN_ACT_SETTING (PRODUCT_STORE_ID, FIN_ACCOUNT_TYPE_ID,
REQUIRE_PIN_CODE, VALIDATE_G_C_FIN_ACCT, ACCOUNT_CODE_LENGTH,
PIN_CODE_LENGTH, ACCOUNT_VALID_DAYS, AUTH_VALID_DAYS,
PURCHASE_SURVEY_ID, PURCH_SURVEY_SEND_TO, PURCH_SURVEY_COPY_ME,
ALLOW_AUTH_TO_NEGATIVE, MIN_BALANCE, REPLENISH_THRESHOLD,
REPLENISH_METHOD_ENUM_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP,
CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?) (Cannot add or update a child row: a foreign
key constraint fails (`ofbiz`.`PRODUCT_STORE_FIN_ACT_SETTING`,
CONSTRAINT `PRSTFNAC_SRVY` FOREIGN KEY (`PURCHASE_SURVEY_ID`)
REFERENCES `SURVEY` (`SURVEY_ID`)))) (Error while inserting:
[GenericEntity:ProductStoreFinActSetting][accountCodeLength,12(java.lang.Long)][accountValidDays,365(java.lang.Long)][allowAuthToNegative,Y(java.lang.String)][authValidDays,5(java.lang.Long)][createdStamp,2018-06-06
18:40:13.609(java.sql.Timestamp)][createdTxStamp,2018-06-06
18:40:13.594(java.sql.Timestamp)][finAccountTypeId,GIFTCERT_ACCOUNT(java.lang.String)][lastUpdatedStamp,2018-06-06
18:40:13.609(java.sql.Timestamp)][lastUpdatedTxStamp,2018-06-06
18:40:13.594(java.sql.Timestamp)][minBalance,null()][pinCodeLength,4(java.lang.Long)][productStoreId,10000(java.lang.String)][purchSurveyCopyMe,copyMe(java.lang.String)][purchSurveySendTo,recipientEmail(java.lang.String)][purchaseSurveyId,1100(java.lang.String)][replenishMethodEnumId,FARP_TOP_OFF(java.lang.String)][replenishThreshold,null()][requirePinCode,N(java.lang.String)][validateGCFinAcct,Y(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO
PRODUCT_STORE_FIN_ACT_SETTING (PRODUCT_STORE_ID, FIN_ACCOUNT_TYPE_ID,
REQUIRE_PIN_CODE, VALIDATE_G_C_FIN_ACCT, ACCOUNT_CODE_LENGTH,
PIN_CODE_LENGTH, ACCOUNT_VALID_DAYS, AUTH_VALID_DAYS,
PURCHASE_SURVEY_ID, PURCH_SURVEY_SEND_TO, PURCH_SURVEY_COPY_ME,
ALLOW_AUTH_TO_NEGATIVE, MIN_BALANCE, REPLENISH_THRESHOLD,
REPLENISH_METHOD_ENUM_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP,
CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?) (Cannot add or update a child row: a foreign
key constraint fails (`ofbiz`.`PRODUCT_STORE_FIN_ACT_SETTING`,
CONSTRAINT `PRSTFNAC_SRVY` FOREIGN KEY (`PURCHASE_SURVEY_ID`)
REFERENCES `SURVEY` (`SURVEY_ID`)))))

[Paul Foxworthy]

Hi Wolfgang,

It's saying the PurchaseSurveyId in your ProductStore refers to a
non-existent Survey with an ID of 1100.

Either create a Survey first, or correct the 1100 to a valid ID for a
Survey, or change the data for the ProductStore so there is no mention of a
Survey.

Cheers

Paul Foxworthy


On 7 June 2018 at 02:44, [hidden email] <[hidden email]>
wrote:

> I get this massive error  message when triying to add fin accts for a store
> The legal entity, GL chart of accounts, etc.. is setup.
>
> Thanks for helping. Wolfgang
>
> 2018-06-06 18:40:13,615 |http-nio-8443-exec-1 |RequestHandler |E| Request
> CreateProductStoreFinAccountSettings caused an error with the following
> message: Error doing entity-auto operation for entity
> ProductStoreFinActSetting in service createProductStoreFinActSetting:
> org.apache.ofbiz.entity.GenericEntityException: org.apache.ofbiz.entity.GenericEntityException:
> Error while inserting: [GenericEntity:ProductStoreFinActSetting][
> accountCodeLength,12(java.lang.Long)][accountValidDays,
> 365(java.lang.Long)][allowAuthToNegative,Y(java.
> lang.String)][authValidDays,5(java.lang.Long)][createdStamp,2018-06-06
> 18:40:13.609(java.sql.Timestamp)][createdTxStamp,2018-06-06
> 18:40:13.594(java.sql.Timestamp)][finAccountTypeId,
> GIFTCERT_ACCOUNT(java.lang.String)][lastUpdatedStamp,2018-06-06
> 18:40:13.609(java.sql.Timestamp)][lastUpdatedTxStamp,2018-06-06
> 18:40:13.594(java.sql.Timestamp)][minBalance,null()]
> [pinCodeLength,4(java.lang.Long)][productStoreId,10000(java.lang.String)][
> purchSurveyCopyMe,copyMe(java.lang.String)][purchSurveySendTo,
> recipientEmail(java.lang.String)][purchaseSurveyId,
> 1100(java.lang.String)][replenishMethodEnumId,FARP_
> TOP_OFF(java.lang.String)][replenishThreshold,null()][
> requirePinCode,N(java.lang.String)][validateGCFinAcct,Y(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO
> PRODUCT_STORE_FIN_ACT_SETTING (PRODUCT_STORE_ID, FIN_ACCOUNT_TYPE_ID,
> REQUIRE_PIN_CODE, VALIDATE_G_C_FIN_ACCT, ACCOUNT_CODE_LENGTH,
> PIN_CODE_LENGTH, ACCOUNT_VALID_DAYS, AUTH_VALID_DAYS, PURCHASE_SURVEY_ID,
> PURCH_SURVEY_SEND_TO, PURCH_SURVEY_COPY_ME, ALLOW_AUTH_TO_NEGATIVE,
> MIN_BALANCE, REPLENISH_THRESHOLD, REPLENISH_METHOD_ENUM_ID,
> LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
> VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Cannot
> add or update a child row: a foreign key constraint fails
> (`ofbiz`.`PRODUCT_STORE_FIN_ACT_SETTING`, CONSTRAINT `PRSTFNAC_SRVY`
> FOREIGN KEY (`PURCHASE_SURVEY_ID`) REFERENCES `SURVEY` (`SURVEY_ID`))))
> (Error while inserting: [GenericEntity:ProductStoreFinActSetting][
> accountCodeLength,12(java.lang.Long)][accountValidDays,
> 365(java.lang.Long)][allowAuthToNegative,Y(java.
> lang.String)][authValidDays,5(java.lang.Long)][createdStamp,2018-06-06
> 18:40:13.609(java.sql.Timestamp)][createdTxStamp,2018-06-06
> 18:40:13.594(java.sql.Timestamp)][finAccountTypeId,
> GIFTCERT_ACCOUNT(java.lang.String)][lastUpdatedStamp,2018-06-06
> 18:40:13.609(java.sql.Timestamp)][lastUpdatedTxStamp,2018-06-06
> 18:40:13.594(java.sql.Timestamp)][minBalance,null()]
> [pinCodeLength,4(java.lang.Long)][productStoreId,10000(java.lang.String)][
> purchSurveyCopyMe,copyMe(java.lang.String)][purchSurveySendTo,
> recipientEmail(java.lang.String)][purchaseSurveyId,
> 1100(java.lang.String)][replenishMethodEnumId,FARP_
> TOP_OFF(java.lang.String)][replenishThreshold,null()][
> requirePinCode,N(java.lang.String)][validateGCFinAcct,Y(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO
> PRODUCT_STORE_FIN_ACT_SETTING (PRODUCT_STORE_ID, FIN_ACCOUNT_TYPE_ID,
> REQUIRE_PIN_CODE, VALIDATE_G_C_FIN_ACCT, ACCOUNT_CODE_LENGTH,
> PIN_CODE_LENGTH, ACCOUNT_VALID_DAYS, AUTH_VALID_DAYS, PURCHASE_SURVEY_ID,
> PURCH_SURVEY_SEND_TO, PURCH_SURVEY_COPY_ME, ALLOW_AUTH_TO_NEGATIVE,
> MIN_BALANCE, REPLENISH_THRESHOLD, REPLENISH_METHOD_ENUM_ID,
> LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
> VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Cannot
> add or update a child row: a foreign key constraint fails
> (`ofbiz`.`PRODUCT_STORE_FIN_ACT_SETTING`, CONSTRAINT `PRSTFNAC_SRVY`
> FOREIGN KEY (`PURCHASE_SURVEY_ID`) REFERENCES `SURVEY` (`SURVEY_ID`)))))
>

--
Coherent Software Australia Pty Ltd
PO Box 2773
Cheltenham Vic 3192
Australia

Phone: [phone]
Web: http://www.coherentsoftware.com.au/
Email: [hidden email]