Welcome Serena Central users! CLICK HERE
The migration of the Serena Central community is currently underway. Be sure to read THIS MESSAGE to get your new login set up to access your account.
JimmyBoy Trusted Contributor.
Trusted Contributor.
566 views

Acu4GL Restricted data type attribute violation

Hi

When attempting an insert to a table running ACu4gl against MS SQL Server

we are getting a 9D00 Restricted data type attribute violation

 

File trace 9 shows

03/26/18 16:03:41 CARRNOTE.DAT: write (thread 1203)
03/26/18 16:03:41 mssql_write, 2414
03/26/18 16:03:41  A46
03/26/18 16:03:41  A47
03/26/18 16:03:41  Stored procedure CARRNOTE_insert was not found in VWFSAUS_USER_JIM_PROD
03/26/18 16:03:41  Preparing SQL on statement 60a3f8 on server 'NSSRVSQL009':
03/26/18 16:03:41  <SQL
03/26/18 16:03:41  insert into VWFSAUS_USER_JIM_PROD.CALMS2CMS_SCHEMA.CARRNOTE  (carr_note_key_source,
03/26/18 16:03:41  carr_note_key_num,
03/26/18 16:03:41  carr_note_tran_no,
03/26/18 16:03:41  carr_note_date,
03/26/18 16:03:41  carr_note_time,
03/26/18 16:03:41  carr_note_text)
03/26/18 16:03:41  values
03/26/18 16:03:41  (?, ?, ?, ?, ?, ?)
03/26/18 16:03:41   EndSQL>
03/26/18 16:03:41  bind_parameter_of_field(1, 02048654, 0)
03/26/18 16:03:41   describe_field 0
03/26/18 16:03:41   Leaving: IT:0, VT:1, PT:1, CS:1, D:0, PV:00000000, BL:1, PBL:02048164
03/26/18 16:03:41  Leaving: VT:1, PT:1, CS:1, D:0, PV:00000000, BL:1, PBL:02048164
03/26/18 16:03:41  bind_parameter_of_field(2, 02048654, 1)
03/26/18 16:03:41   describe_field 1
03/26/18 16:03:41   Leaving: IT:0, VT:1, PT:4, CS:10, D:0, PV:020481C4, BL:35, PBL:020481FC
03/26/18 16:03:41  Leaving: VT:1, PT:4, CS:10, D:0, PV:020481C4, BL:35, PBL:020481FC
03/26/18 16:03:41  bind_parameter_of_field(3, 02048654, 2)
03/26/18 16:03:41   describe_field 2
03/26/18 16:03:41   Leaving: IT:0, VT:1, PT:4, CS:10, D:0, PV:0204825C, BL:35, PBL:02048294
03/26/18 16:03:41  Leaving: VT:1, PT:4, CS:10, D:0, PV:0204825C, BL:35, PBL:02048294
03/26/18 16:03:41  bind_parameter_of_field(4, 02048654, 3)
03/26/18 16:03:41   describe_field 3
03/26/18 16:03:41   Leaving: IT:0, VT:93, PT:4, CS:10, D:0, PV:020482F4, BL:35, PBL:0204832C
03/26/18 16:03:41  Leaving: VT:93, PT:4, CS:10, D:0, PV:020482F4, BL:35, PBL:0204832C
03/26/18 16:03:41  report_status called from 9707
03/26/18 16:03:41   [1] 07006 0 - Restricted data type attribute violation
03/26/18 16:03:41  No more messages
03/26/18 16:03:41 Leaving, BindParameter 4
03/26/18 16:03:41 *** File system error value = 0 ***
03/26/18 16:03:41 *** Restricted data type attribute violation                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         ***
03/26/18 16:03:41 >>>file status = 9D

0 Likes
4 Replies
Micro Focus Expert
Micro Focus Expert

RE: Acu4GL Restricted data type attribute violation

Are you using a MSSQL 2008 client ... docs.microsoft.com/.../cross-version-compatibility
0 Likes
DougP Outstanding Contributor.
Outstanding Contributor.

RE: Acu4GL Restricted data type attribute violation

What version of Acu4GL are you using?
What is your setting for A_MSSQL_ODBC_DRIVER_NAME?
0 Likes
Chuck Edgin Absent Member.
Absent Member.

RE: Acu4GL Restricted data type attribute violation

My guess is that in your database, you've got a table trigger on CARRNOTE, set to fire on an INSERT, which tries to run a stored procedure named CARRNOTE_insert. And that stored procedure is missing, got renamed or deleted, or is otherwise inaccessible.
0 Likes
JimmyBoy Trusted Contributor.
Trusted Contributor.

RE: Acu4GL Restricted data type attribute violation

Thanks All
We found that the XFD in use had ,YYYYMMDD at the end .... that is because there used to be an XFD directive in the FD that set the date field to TYPE of DATE
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.