Process "Internal Error"

vinsnash

The process listed below has two rules 1 & 2. UnitTable has a reference attribute 'CORD' indicating NSCPers as the type. When executed the process fails with a message "Internal Error". The log shows nothing unusual. Just a last entry "Process Failed". How does one go about determining what is causing the failure?

To start with there are no instances of UnitTable. The intent is to create a UnitTable instance populated with the reference data in the reference attribute "CORD" for each found NSCPers. The log shows that 295 instances of NSCPers where NSCPers.CO='Yes' were found, the Create Action was added and started. Then the "Process Failed" entry. That is all that is indicated.

The rule was created with the process editor and showed no syntax errors when created and saved.

Vins Nash

ProcessRule1

FIND NSCPers WHERE NSCPers.CO = 'Yes'

ProcessRule2

IF EXISTS UnitTable WHERE (UnitTable.UnitCode = NSCPers.UnitCode)THEN
FIND UnitTable WHERE UnitTable.UnitCode = NSCPers.UnitCode
UnitTable.CORD.Rank=NSCPers.Rank
UnitTable.CORD.FirstName=NSCPers.FirstName
UnitTable.CORD.LastName=NSCPers.LastName
UnitTable.CORD.Branch=NSCPers.Branch
UnitTable.CORD.Address=NSCPers.Address
UnitTable.CORD.City=NSCPers.City
UnitTable.CORD.State=NSCPers.State
UnitTable.CORD.ZIP=NSCPers.ZIP
UnitTable.CORD.HomePhone=NSCPers.HomePhone
UnitTable.CORD.WorkPhone=NSCPers.WorkPhone

ELSE

CREATE UnitTable WITH UnitTable.UnitCode = NSCPers.UnitCode,
UnitTable.CORD.Rank=NSCPers.Rank,
UnitTable.CORD.FirstName=NSCPers.FirstName,
UnitTable.CORD.LastName=NSCPers.LastName,
UnitTable.CORD.Branch=NSCPers.Branch,
UnitTable.CORD.Address=NSCPers.Address,
UnitTable.CORD.City=NSCPers.City,
UnitTable.CORD.State=NSCPers.State,
UnitTable.CORD.ZIP=NSCPers.ZIP,
UnitTable.CORD.HomePhone=NSCPers.HomePhone,
UnitTable.CORD.WorkPhone=NSCPers.WorkPhone

tford

Vins,

Looks like another example of where you need to consider "IN BATCHES OF 1" in the FIND in the first process ???

You can also refer to notes at:

vinsnash

Thanks. Shortly after I posted that I found another similar post recommending using INSERT. I was thinking along the lines of manually adding references to an object instance and only entering the data desired and not populating every attribute.

In this case the reference object instance exists so it is "INSERTED" in the reference attribute. That works nicely.

Still the process rule editor led me through the selections for the "CREATE WITH" and selecting attributes of the reference without any apparent error. The "Internal Error" message is meaningless and the log gives no indication of the reason for failure at all.

Another topic for the "Dummies" book.

Vins Nash

vinsnash

What would be extremely helpful is an upgrade to the search engine for this forum so users could pin down more precisely what they're looking for without getting hits on every word of a phrase like "process internal error". There would be much less duplication of problem inquiries and new user learning curves would be a lot shorter.

Vins Nash