Wish list
If you like this blog and want to say thanks in some way, here is my wish-list on Amazon. It'll be very cool to get a gift from my subscribers. Just don't forget to put your name on it -)Tags
Category Archives: Admin Console
Picklist search
Sometimes it is handy to have a deeper look on the HR.Net Picklists. Picklists are set values of text data. Opposing to plain text fields, picklists can have only set number of values and can not be easily changed by … Continue reading
Screen changes do not go through
After the update to HR.Net 3.0 we encountered a new problem: changes to screens/workflow forms done in Admin Console did not come up on the actual front-end. In the previous version it took about a minute to get the updated … Continue reading
The way your data is retrieved
Recently we noticed a bunch of email notification going to folks with outdated information. I’ve checked the mailers in the workflows: information is taken via “Input table/Values/….”. And after some thought I came up with a question: when does the … Continue reading
Failed to insert a record via a Screen.
During the export of our legacy Issue Tracking system into HR.Net, I faced a problem that looks like this: The error was saying that something inside HR.Net do miss field called NOTENO in table ISSUENOTES. During the export of the … Continue reading
Database writer stall error ‘Cannot set Column ‘XXXX’ to be null’
Describes a stall error that can occur on a database writer when writing lookup values – ‘Cannot set Column ‘XXXX’ to be null’. Please use DBNull instead. Workflow stalling at the database writer stage with the following error: Exception: Cannot … Continue reading
Posted in Admin Console
Leave a comment
Error saying “Violation of PRIMARY KEY constraint ‘OC_WORKFLOWCACHEPARAMETERS_PK'”
Talking about an issue that can occur that results in a stalled instance in the Workflow Instances with the error as described. Viewing the Workflow stalled instances displays the following error message. Exception: Violation of PRIMARY KEY constraint ‘OC_WORKFLOWCACHEPARAMETERS_PK’. Cannot … Continue reading
Posted in Admin Console
Tagged Constraint, Duplicate, Instances, Primary Key, Violation, workflow
Leave a comment
Incorrect Foreign Key Data returned in a table trigger if the child data is opened from a data grid
This article describes an issue that occurs when a table trigger is fired by the editing of a child table that has been opened from a screen that is not the parent. Description of the problem: 1. A table trigger … Continue reading
Unable to send Mail-Merge to hard-coded email
Unfortunately, although the Mail merge stage allows you to select a hard-coded email address, this option doesn’t currently work. When you are trying to send a Mail Merge to hard-coded email address, it fails to do so. It does not … Continue reading
Mail Merge stage in workflow not sending to recipients mapped from a Database Reader
This article describes an issue that can occur with Mail Merge stages when using the recipients option “Message User” in conjunction with a list of people returned from a database reader. When using a database reader to determine the recipients … Continue reading
Message “The child record you are trying to save does not have any parent record.” when adding data.
Describes an issue that can occur when a save for a new record opened from a datagrid is attempted. Message “The child record you are trying to save does not have any parent record.” displayed when clicking save on a … Continue reading