Hello,
No i don´t have. When I create ofbiz without demo data I have nothing
created.
At the moment, i try to add the relationships to the entities. But i have
a exception when i try to link the "LeadOwner(Personal Information)" and
the "Group of Lead Owners(Party Group Information). But i get the following
error:
------Start Error------
The Following Errors Occurred:
Exception thrown while creating the "newEntity" GenericValue:
org.apache.ofbiz.entity.GenericEntityException: Error while inserting:
[GenericEntity:PartyRelationship][comments,null()][createdStamp,2021-10-21
13:34:43.291(java.sql.Timestamp)][createdTxStamp,2021-10-21
13:34:43.258(java.sql.Timestamp)][fromDate,2021-10-21
13:34:13.0(java.sql.Timestamp)][lastUpdatedStamp,2021-10-21
13:34:43.291(java.sql.Timestamp)][lastUpdatedTxStamp,2021-10-21
13:34:43.258(java.sql.Timestamp)][partyIdFrom,DemoLeadOwnersGroup(java.lang.String)][partyIdTo,DemoLeadOwner(java.lang.String)][partyRelationshipTypeId,LEAD_OWN_GRP_MEMBER(java.lang.String)][roleTypeIdFrom,INTERNAL_ORGANIZATIO(java.lang.String)][roleTypeIdTo,OWNER(java.lang.String)][securityGroupId,null()][statusId,PARTYREL_CREATED(java.lang.String)][thruDate,null()]
(SQL Exception while executing the following:INSERT INTO PARTY_RELATIONSHIP
(PARTY_ID_FROM, PARTY_ID_TO, ROLE_TYPE_ID_FROM, ROLE_TYPE_ID_TO, FROM_DATE,
THRU_DATE, STATUS_ID, RELATION
SHIP_NAME, SECURITY_GROUP_ID, PRIORITY_TYPE_ID,
PARTY_RELATIONSHIP_TYPE_ID, PERMISSIONS_ENUM_ID, POSITION_TITLE, COMMENTS,
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`.`party_relationship`, CONSTRAINT `PARTY_REL_FPROLE` FOREIGN KEY
(`PARTY_ID_FROM`, `ROLE_TYPE_ID_FROM`) REFERENCES `PARTY_ROLE` (`PARTY_ID`,
`ROLE_TYPE_ID`)))) (Error while inserting:
[GenericEntity:PartyRelationship][comments,null()][createdStamp,2021-10-21
13:34:43.291(java.sql.Timestamp)][createdTxStamp,2021-10-21
13:34:43.258(java.sql.Timestamp)][fromDate,2021-10-21
13:34:13.0(java.sql.Timestamp)][lastUpdatedStamp,2021-10-21
13:34:43.291(java.sql.Timestamp)][lastUpdatedTxStamp,2021-10-21
13:34:43.258(java.sql.Timestamp)][partyIdFrom,DemoLeadOwnersGroup(java.lang.String)][partyIdTo,DemoLeadOwner(java.lang.String)][partyRelationshipTypeId,LEAD_OWN_GRP_
MEMBER(java.lang.String)][roleTypeIdFrom,INTERNAL_ORGANIZATIO(java.lang.String)][roleTypeIdTo,OWNER(java.lang.String)][securityGroupId,null()][statusId,PARTYREL_CREATED(java.lang.String)][thruDate,null()]
(SQL Exception while executing the following:INSERT INTO PARTY_RELATIONSHIP
(PARTY_ID_FROM, PARTY_ID_TO, ROLE_TYPE_ID_FROM, ROLE_TYPE_ID_TO, FROM_DATE,
THRU_DATE, STATUS_ID, RELATIONSHIP_NAME, SECURITY_GROUP_ID,
PRIORITY_TYPE_ID, PARTY_RELATIONSHIP_TYPE_ID, PERMISSIONS_ENUM_ID,
POSITION_TITLE, COMMENTS, 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`.`party_relationship`, CONSTRAINT
`PARTY_REL_FPROLE` FOREIGN KEY (`PARTY_ID_FROM`, `ROLE_TYPE_ID_FROM`)
REFERENCES `PARTY_ROLE` (`PARTY_ID`, `ROLE_TYPE_ID`)))))
-----END Error -------
On 2021/10/21 08:11:31, Pierre Smits <[email protected]> wrote:
Hi Rodrigo,
Do you have the primary company in your data set? This needs to exist.
Have
a look at the demo data set, see the data regarding '<Party
partyId="Company"/> and related.
Met vriendelijke groet,
Pierre Smits
*Proud* *contributor** of* Apache OFBiz <https://ofbiz.apache.org/>
since
2008 (without privileges)
*Apache Directory <https://directory.apache.org>, PMC Member*
Apache Incubator <https://incubator.apache.org>, committer
Apache Steve <https://steve.apache.org>, committer
On Wed, Oct 20, 2021 at 4:19 PM Rodrigo Baptista <
[email protected]> wrote:
Hello,
i have a problem with ofbiz. I installed the version 17.12 and 18.12
and i
have the same issue with both versions.
What I do:
1. Installed Ofbiz with initial seed data. (./gradlew "ofbiz
--load-data
readers=seed,seed-initial" loadAdminUserLogin -PuserLoginId=admin)
2. Start ofbiz (./gradlew ofbiz)
3. open HR View (/humanres/control/main)
Now i have always a exception in my logs cause by the partyId is null:
logs:
----Start Log-----
freemarker.core.InvalidReferenceException: The following has evaluated
to
null or missing:
==> partyId [in template
"component://humanres/template/category/CategoryTree.ftl" at line 60,
column 44]
----
Tip: If the failing expression is known to legally refer to something
that's sometimes null or missing, either specify a default value like
myOptionalVar!myDefault, or use <#if
myOptionalVar??>when-present<#else>when-missing</#if>. (These only
cover
the last step of the expression; to cover the whole expression, use
parenthesis: (myOptionalVar.foo)!myDefault, (myOptionalVar.foo)??
----
FTL stack trace ("~" means nesting-related):
- Failed at: ${partyId} [in template
"component://humanres/template/category/CategoryTree.ftl" at line 60,
column 42]
——
----End Log--------
What i need is to create a company to manage the company.
I created also a company with the documentation (
https://cwiki.apache.org/confluence/display/OFBIZ/How+to+Setup+a+Company)
and it not fixed the issue.
Does anybody have a solution for me?
regards Rodrigo Baptista
