iMIS 10.6

Extracting data from iMIS 10 and/or identifying field names in iMIS 10

I am migrating to another system from iMIS 10.6 and would like assitance with two questions:

1) Is there a developer or "designer" mode in iMIS that tells the user what the formal field name of a field is?  I have access to the data dictionary document with the formal field names but it does not clearly indicate which field each refers to.  My purpose here is to map field names from iMIS to the new system.

*Database deadlocking -

I have a client running 10.6.30.17 with an intermittent on-line payment issue which I would like to throw open to the community for comment. All suggestions appreciated :-)

The issue is, about 2% of on-line transactions are failing with database deadlock issues. Stored procedure asiGetCounter deadlocks when retrieving next TRANS counter value.

The deadlocks happens when

Error Message when inserting Activity/ creating invoice from Order

This is the message i get when trying to insert a new activity to Manage Committees and when converting an order to an invoice.  I am not sure if this is the proper place to post it or if is is related to the SQL server or something else.
WinIO/63 2627
23000:[Microsoft][ODBC SQL Server dirver] [SQL Server]Violation of PRIMARY KEY contraint ‘pkActivitySEQN’.
Cannot insert duplicate key in object’dbo.Activity’. 01000:[Microsoft][ODBC SQUL Server Driver] [SQUL Server]The statement has been terminated.

Subreports in iMIS

Hi I had a question about subreports and iMIS.  I created a subreport but I am having trouble accessing it in iMIS.  I created the report and subreport with 2 different VIEWs and granted both of them access to iMIS and uploaded them to iMIS.  When I click on the report, it loads up fine, however, I can not click on the subreport.  It looks like a link but it does not let me click on it.  Does anyone know how to get around this?

ASIUtil.CCrypto 64 bit version?

I am in the process of converting from a 32 bit to a 64 bit server.  We have a custom registration application in Coldfusion that calls the COM object ASIUtil.CCrypto.  I get the following error:

Normal
0

false
false
false

EN-US
X-NONE
X-NONE


D:\ColdFusion9\jintegra\bin\ntvinv.dll: Can't load IA 32-bit .dll on a AMD 64-bit platform null

iMIS 10.6 and Windows 7

Has anyone had any experience using the 10.6 release client on a Windows 7 OS? We skipped Vista altogether but will likely upgrade to Windows 7 soon and need to know if upgrading to Windows 7 must be preceeded by an upgrade to iMIS 15.

iMis 15 Licensing with Multi-Instance

When upgrading multiple co-existing instances to 15.1 does anyone have a good process suggestion for being able to upgrade the databases seeing as how it requires an update to the license? We're using the multi-instance process for the web server but hate to install/uninstall the application on my desktop that many times to go through the upgrade process. If we didn't have to worry about the license we could just use the dbupgrader.exe directly. We are upgrading from 10.6 to 15.1.2 so we do not have the proper licensing to allow the upgrade using dbupgrader.exe without having the new licensing in place first.

IBO for .NET

I am new to programming the .net IBOs so here is my first challenge connecting to the IMIS database

I created a windows appliction and added a reference to the asi.ibo.dll and write the following code behind a simple button

imports asi.ibo

 Dim i As Integer Dim cn As String

 

Every page is password protected

When I did an entire import from eCM to wCM for a customer site, every page within the wCM site that I have is password protected. I've checked permissions on both the sitemap and the content records and can't find anywhere where settings dictate a required login. Any ideas?

Content and HTML content Images aren't appearing on site

I'm having another strange issue. I've got a DEV site and a TEST site. On the test site, I modified a template design successfully. I then moved the entire template design to the DEV site and images aren't appearing on the site when I'm logged in - content images and images within content HTML records. When i'm logged out, the content images are appearing as they should. Any suggestions?