Author Archives: admin

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

Posted in Admin Console, Applications Server, SQL Server | Tagged , , | Leave a comment

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

Posted in Admin Console | Tagged , | Leave a comment

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

Posted in Admin Console | Tagged | Leave a comment

Change the start number of autogenerated field value

Sometimes you have auto-generated fields in tables. Most of the times this field is a ID-number of an item. And not every time you want to start numbers from 0. For example, I have to export some historic data into … Continue reading

Posted in SQL Server | Tagged | Leave a comment

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 , , , , , | 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

Posted in Admin Console | Tagged , , , | Leave a comment

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

Posted in Admin Console | Tagged , , | Leave a comment

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

Posted in Admin Console | Tagged , | Leave a comment

Error ‘Invalid Argument.” when using the Web App – Navigator

Describes an error that can result in the following error message when using the Navigator on the Web App. Error:    Invalid Argument Symptoms: If you select an Application type and then select a Table, before the system has refreshed, the … Continue reading

Posted in Uncategorized | Leave a comment