If you’re experiencing constraint violation errors when debugging code or processes in Creatio, it can sometimes be difficult to understand where exactly the problem lies. This article will outline how to troubleshoot these types of errors. Background In Creatio, when you add a lookup to an entity object, it adds a database-level constraint that enforces […]
In order to connect Infor CRM software to the database, you must set set up the Data Link in Connection Manager; and set up the connection to the Data Link in Data Link Manager.
In order to prepare a SQL server to run Infor CRM, you must set up a SQL login for CRM to use, and must link it with the sysdba user in the CRM database.
Use the sa SQL account to move or restore CRM databases, but use sysdba to connect to them.
Some entities in Infor CRM (Saleslogix), such as Tickets, use a “pretty key” as an easier to use value to reference the record. These pretty keys take a table ID value and then create a value like 000-00-001234. If you are creating an external application with this functionality, you’ll need to be able to create […]
Most of the SalesLogix systems I see now days no longer use remote users. Instead, all users VPN into a central network to access SalesLogix, or use the SalesLogix Web and Mobile clients instead for remote users. This removes the need to worry about things like synchronization for remote users and also allows you to do some SalesLogix table manipulation without going through the SalesLogix OLE DB Provider since things no longer have to be "s...
A question came up from a person attending our current Report Writing class about how to flatten out data that exists as multiple rows in the database to a single string in a report. There is a really cool trick you can do in SQL to accomplish this which I previously outlined in a post on my personal blog where I outline a technique that can be used to make a query append each value from the rows in the query to a variable. Without using cursors,...
Ok, I see in my logs constantly google searches for “fixing the sysdba user“ that lead to this blog. This is a common thing I find in my logs, but strangely enough, I’ve never posted anything about fixing the sysdba user. So, drumroll… sp_change_users_login 'Update_One', 'sysdba', 'sysdba' Ta-da! For people who work with SalesLogix […]
Subscribe To Our Newsletter
Join our mailing list to receive the latest Infor CRM (Saleslogix) and Creatio (bpm'online) news and product updates!
You have Successfully Subscribed!