Solomon Transaction Import Release Notes



Yüklə 309 Kb.
səhifə5/5
tarix18.07.2018
ölçüsü309 Kb.
#56374
1   2   3   4   5

Tran Code:

Empty & there is default in DB




Batch is created in DBs.

TI assigns system’s default tran code to imported record.



Batch is created in DBs.

TI assigns system’s default tran code to imported record.



79

Tran Code:

Empty & no current biennium’s default









80

Tran Code:

Zero & there is default in DBs.





Reject entire file

No batch created in DBs.


Invalid record is searchable with: 'System Message 9: Item not found, please reenter.
'System Message 8002: Error In Field: ctrancode_2 Value: ""0"" Column 55
'System Message 8004: Data File Record/Line Number: 3 Column: 55
'System Message 8055: ========Error Processing Transaction Data Line
Valid record immediately follows invalid record is searchable with:
'Application Error: A valid AR Type must be provided for the batch before transactions can be entered.
'System Message 2: Data must be entered in this field
'System Message 8034: Error in Field: cartype_0 Value:
Remaining valid record are searchable by:

'System Message 8055: ========Error Processing Document Data Line========


'Application Error: A valid AR Type must be provided for the batch before transactions can be entered.’
'System Message 2: Data must be entered in this field
'System Message 8034: Error in Field: cartype_0 Value:
Best recognition of error is that a batch number was not assigned, indicating that a batch was not created and that the entire data file failed the import.

Batch is created in DBs.

Reject invalid record.
Invalid record is searchable with: 'System Message 9: Item not found, please reenter.
'System Message 8002: Error In Field: ctrancode_2 Value: ""0"" Column 54
'System Message 8004: Data File Record/Line Number: 7 Column: 54
'System Message 8055: ========Error Processing Transaction Data Line



81

Tran Code:

Invalid value: Negative




Reject entire file.

No batch created in DBs.


Invalid record is searchable with: 'System Message 8002: Error In Field: ctrancode_2 Value: ""-012"" Column 55
'System Message 8033: Invalid data. Value ""-012"" does not match Mask ""WWW""
'System Message 8055: ========Error Processing Transaction Data Line========
Valid record immediately follows invalid record is searchable with:
'Application Error: A valid AR Type must be provided for the batch before transactions can be entered.
'System Message 2: Data must be entered in this field
'System Message 8034: Error in Field: cartype_0 Value:
Remaining valid record are searchable by:

'System Message 8055: ========Error Processing Document Data Line========


'Application Error: A valid AR Type must be provided for the batch before transactions can be entered.’
'System Message 2: Data must be entered in this field
'System Message 8034: Error in Field: cartype_0 Value:
Best recognition of error is that a batch number was not assigned, indicating that a batch was not created and that the entire data file failed the import.

Batch is created.

Reject invalid record.
Invalid record is searchable with: 'System Message 8002: Error In Field: ctrancode_2 Value: ""-012"" Column 54
'System Message 8033: Invalid data. Value ""-012"" does not match Mask ""WWW""
'System Message 8055: ========Error Processing Transaction Data Line



82

Tran Code:

Invalid value: Alpha (length, character type, not in table)





Reject entire file

No batch is created in DBs.


Invalid record is searchable with: 'System Message 9: Item not found, please reenter.
'System Message 8002: Error In Field: ctrancode_2 Value: ""PDQ"" Column 55
'System Message 8004: Data File Record/Line Number: 3 Column: 55
'System Message 8055: ========Error Processing Transaction Data Line
Valid record immediately follows invalid record is searchable with:
'Application Error: A valid AR Type must be provided for the batch before transactions can be entered.
'System Message 2: Data must be entered in this field
'System Message 8034: Error in Field: cartype_0 Value:
Remaining valid record are searchable by:

'System Message 8055: ========Error Processing Document Data Line========


'Application Error: A valid AR Type must be provided for the batch before transactions can be entered.’
'System Message 2: Data must be entered in this field
'System Message 8034: Error in Field: cartype_0 Value:
Best recognition of error is that a batch number was not assigned, indicating that a batch was not created and that the entire data file failed the import.

Batch is created in DBs.

Reject invalid record.
Invalid record is searchable with: 'System Message 9: Item not found, please reenter.
'System Message 8002: Error In Field: ctrancode_2 Value: ""PDQ"" Column 54
'System Message 8004: Data File Record/Line Number: 7 Column: 54
'System Message 8055: ========Error Processing Transaction Data Line

83

Tran Code:

Invalid value: Symbols




Reject entire file.

No batch created in DBs.


Invalid record is searchable with: 'System Message 8002: Error In Field: ctrancode_2 Value: ""@#$"" Column 55
'System Message 8033: Invalid data. Value ""@#$"" does not match Mask ""WWW""
'System Message 8055: ========Error Processing Transaction Data Line========
Valid record immediately follows invalid record is searchable with:
'Application Error: A valid AR Type must be provided for the batch before transactions can be entered.
'System Message 2: Data must be entered in this field
'System Message 8034: Error in Field: cartype_0 Value:
Remaining valid record are searchable by:

'System Message 8055: ========Error Processing Document Data Line========


'Application Error: A valid AR Type must be provided for the batch before transactions can be entered.’
'System Message 2: Data must be entered in this field
'System Message 8034: Error in Field: cartype_0 Value:
Best recognition of error is that a batch number was not assigned, indicating that a batch was not created and that the entire data file failed the import.

Batch is created in DBs.

Reject invalid record.
Invalid record is searchable with: 'System Message 8002: Error In Field: ctrancode_2 Value: ""@#$"" Column 54
'System Message 8033: Invalid data. Value ""@#$"" does not match Mask ""WWW""
'System Message 8055: ========Error Processing Transaction Data Line========



84

Tran Code:

Invalid value: Length greater than 3 characters with the first 3 characters matching a value in DBs.



Batch is created in DBs.

Import truncates Tran code to 3 digits.




Batch is created in DBs.

Import truncates Tran Code to 3 digits.



85

Tran Code:

Invalid value: Length greater than 3 characters, with the first 3 characters not matching value exists in DBs.





Reject entire file.

No batch created in DBs.


Invalid record is searchable with: 'System Message 9: Item not found, please reenter.
'System Message 8002: Error In Field: ctrancode_2 Value: ""000"" Column 55
'System Message 8004: Data File Record/Line Number: 3 Column: 55
'System Message 8055: ========Error Processing Transaction Data Line========
Valid record immediately follows invalid record is searchable with:
'Application Error: A valid AR Type must be provided for the batch before transactions can be entered.
'System Message 2: Data must be entered in this field
'System Message 8034: Error in Field: cartype_0 Value:
Remaining valid record are searchable by:

'System Message 8055: ========Error Processing Document Data Line========


'Application Error: A valid AR Type must be provided for the batch before transactions can be entered.’
'System Message 2: Data must be entered in this field
'System Message 8034: Error in Field: cartype_0 Value:
Best recognition of error is that a batch number was not assigned, indicating that a batch was not created and that the entire data file failed the import.

Batch is created in DBs.

Reject invalid record.
Invalid record is searchable with: 'System Message 9: Item not found, please reenter.
'System Message 8002: Error In Field: ctrancode_2 Value: ""000"" Column 54
'System Message 8004: Data File Record/Line Number: 7 Column: 54
'System Message 8055: ========Error Processing Transaction Data Line========

86

Fund:

Empty & there is default in DBs.



Batch is created in DBs.

TI assigns system’s default fund to imported record.



Batch is created in DBs.

TI assigns system’s default fund to imported record.



87

Fund:

Empty & there is NO current biennium default in DBs.





Reject entire file

No batch created in DBs


Invalid record is searchable with: 'Application Error: Cant find default AFRS Code for AR Type NO and DocCat ND
'System Message 8034: Error in Field: cfund_2 Value:
'System Message 2: Data must be entered in this field
Valid record immediately follows invalid record is searchable with: 'System Message 8055: ========Error Processing Document Data Line========
'Application Error: A valid AR Type must be provided for the batch before transactions can be entered.
'System Message 2: Data must be entered in this field
'System Message 8034: Error in Field: cartype_0 Value:
Remaining valid record are searchable by:

'System Message 8055: ========Error Processing Document Data Line========


'Application Error: A valid AR Type must be provided for the batch before transactions can be entered.’
'System Message 2: Data must be entered in this field
'System Message 8034: Error in Field: cartype_0 Value:
Best recognition of error is that a batch number was not assigned, indicating that a batch was not created and that the entire data file failed the import.

Batch is created in DBs

Reject invalid record.
Valid records prior to invalid record have the following log: 'Application Error: Cant find default AFRS Code for AR Type NO and DocCat ND
Invalid record is searchable with: 'Application Error: Cant find default AFRS Code for AR Type NO and DocCat ND
'System Message 8034: Error in Field: cfund_2 Value:
'System Message 2: Data must be entered in this field
Valid record immediately follows invalid record is searchable with: 'System Message 8055: ========Error Processing Document Data Line
'Application Error: Cant find default AFRS Code for AR Type NO and DocCat ND
Remaining valid record are searchable by: 'Application Error: Cant find default AFRS Code for AR Type NO and DocCat ND



88

Fund:

Zero




Reject entire file

No batch created in DBs.


Invalid record is searchable with: 'System Message 9: Item not found, please reenter.
'System Message 8002: Error In Field: cfund_2 Value: ""0"" Column 49
'System Message 8004: Data File Record/Line Number: 3 Column: 49
'System Message 8055: ========Error Processing Transaction Data Line
Valid record immediately follows invalid record is searchable with:
'Application Error: A valid AR Type must be provided for the batch before transactions can be entered.
'System Message 2: Data must be entered in this field
'System Message 8034: Error in Field: cartype_0 Value:
Remaining valid record are searchable by:

'System Message 8055: ========Error Processing Document Data Line========


'Application Error: A valid AR Type must be provided for the batch before transactions can be entered.’
'System Message 2: Data must be entered in this field
'System Message 8034: Error in Field: cartype_0 Value:
Best recognition of error is that a batch number was not assigned, indicating that a batch was not created and that the entire data file failed the import.

Batch is created in DBs.

Reject invalid record.
Invalid record is searchable with: 'System Message 9: Item not found, please reenter.
'System Message 8002: Error In Field: cfund_2 Value: ""0"" Column 48
'System Message 8004: Data File Record/Line Number: 7 Column: 48
'System Message 8055: ========Error Processing Transaction Data Line========

89

Fund:

Invalid value: Negative





Reject entire file

No batch created in DBs.


Invalid record is searchable with: 'System Message 8002: Error In Field: cfund_2 Value: ""-543"" Column 49
'System Message 8033: Invalid data. Value ""-543"" does not match Mask ""WWW""
'System Message 8055: ========Error Processing Transaction Data Line
Valid record immediately follows invalid record is searchable with:
'Application Error: A valid AR Type must be provided for the batch before transactions can be entered.
'System Message 2: Data must be entered in this field
'System Message 8034: Error in Field: cartype_0 Value:
Remaining valid record are searchable by:

'System Message 8055: ========Error Processing Document Data Line========


'Application Error: A valid AR Type must be provided for the batch before transactions can be entered.’
'System Message 2: Data must be entered in this field
'System Message 8034: Error in Field: cartype_0 Value:
Best recognition of error is that a batch number was not assigned, indicating that a batch was not created and that the entire data file failed the import.

Batch is created in DBs.

Reject invalid record.
Invalid record is searchable with: 'System Message 8002: Error In Field: cfund_2 Value: ""-543"" Column 48
'System Message 8033: Invalid data. Value ""-543"" does not match Mask ""WWW""
'System Message 8055: ========Error Processing Transaction Data Line

90

Fund:

Invalid value: Alpha (length, character type, not in table)




Reject entire file.

No batch created in DBs.


Invalid record is searchable with: 'System Message 9: Item not found, please reenter.
'System Message 8002: Error In Field: cfund_2 Value: ""ZZZ"" Column 49
'System Message 8004: Data File Record/Line Number: 3 Column: 49
'System Message 8055: ========Error Processing Transaction Data Line
Valid record immediately follows invalid record is searchable with:
'Application Error: A valid AR Type must be provided for the batch before transactions can be entered.
'System Message 2: Data must be entered in this field
'System Message 8034: Error in Field: cartype_0 Value:
Remaining valid record are searchable by:

'System Message 8055: ========Error Processing Document Data Line========


'Application Error: A valid AR Type must be provided for the batch before transactions can be entered.’
'System Message 2: Data must be entered in this field
'System Message 8034: Error in Field: cartype_0 Value:
Best recognition of error is that a batch number was not assigned, indicating that a batch was not created and that the entire data file failed the import.

Batch is created in DBs.

Reject invalid record.
Invalid record is searchable with: 'System Message 9: Item not found, please reenter.
'System Message 8002: Error In Field: cfund_2 Value: ""ZZZ"" Column 48
'System Message 8004: Data File Record/Line Number: 7 Column: 48
'System Message 8055: ========Error Processing Transaction Data Line========

91

Fund:

Invalid value: Symbols




Reject entire file

No batch created in DBs.


Invalid record is searchable with: 'System Message 8002: Error In Field: cfund_2 Value: ""@#$"" Column 49
'System Message 8033: Invalid data. Value ""@#$"" does not match Mask ""WWW""
'System Message 8055: ========Error Processing Transaction Data Line
Valid record immediately follows invalid record is searchable with:
'Application Error: A valid AR Type must be provided for the batch before transactions can be entered.
'System Message 2: Data must be entered in this field
'System Message 8034: Error in Field: cartype_0 Value:
Remaining valid record are searchable by:

'System Message 8055: ========Error Processing Document Data Line========


'Application Error: A valid AR Type must be provided for the batch before transactions can be entered.’
'System Message 2: Data must be entered in this field
'System Message 8034: Error in Field: cartype_0 Value:
Best recognition of error is that a batch number was not assigned, indicating that a batch was not created and that the entire data file failed the import.

Batch is created in DBs.

Reject invalid record.
Invalid record is searchable with: 'System Message 8002: Error In Field: cfund_2 Value: ""@#$"" Column 48
'System Message 8033: Invalid data. Value ""@#$"" does not match Mask ""WWW""
'System Message 8055: ========Error Processing Transaction Data Line========

92

Fund:

Invalid value: large 543999 but with first 3 digits matching a valid value in DBs.



Batch is created in DBs.

Import truncates Fund to 3 digits and edit against DBs.





Batch is created in DBs.

Import truncates Fund to 3 digits and edit against DBs



93

Fund:

Invalid value: Numeric and Alpha (999X.45)





Reject entire file

No batch created in DBs.


Invalid record is searchable with: 'System Message 9: Item not found, please reenter.
'System Message 8002: Error In Field: cfund_2 Value: ""Z22"" Column 49
'System Message 8004: Data File Record/Line Number: 3 Column: 49
'System Message 8055: ========Error Processing Transaction Data Line========
Valid record immediately follows invalid record is searchable with:
'Application Error: A valid AR Type must be provided for the batch before transactions can be entered.
'System Message 2: Data must be entered in this field
'System Message 8034: Error in Field: cartype_0 Value:
Remaining valid record are searchable by:

'System Message 8055: ========Error Processing Document Data Line========


'Application Error: A valid AR Type must be provided for the batch before transactions can be entered.’
'System Message 2: Data must be entered in this field
'System Message 8034: Error in Field: cartype_0 Value:
Best recognition of error is that a batch number was not assigned, indicating that a batch was not created and that the entire data file failed the import.

Batch is created in DBs.

Reject invalid record.
Invalid record is searchable with: 'System Message 9: Item not found, please reenter.
'System Message 8002: Error In Field: cfund_2 Value: ""ZZ9"" Column 48
'System Message 8004: Data File Record/Line Number: 7 Column: 48
'System Message 8055: ========Error Processing Transaction Data Line========







94

Other:

Invalid File extension

File .txt

Note: Must select ‘All Files (*.*) from File Type dropdown.



Will import.

Will import.

95

Other:

Invalid File extension

File .doc

Note: Must select ‘All Files (*.*) from File Type dropdown.



Will import.

Will import.

96

Other:

Invalid File single quotes for field delimiter



Will not import, treats file as one record:

'System Message 2: Data must be entered in this field
'System Message 8034: Error in Field: cartype_0 Value:

N/A

97

Other:

Invalid File TAB for field separator



Will not import, treats file as one record:

'System Message 2: Data must be entered in this field
'System Message 8034: Error in Field: cartype_0 Value:

N/A

98

Other:

Maximum file size (32,000 characters)









99

Other:

Access file import









100

Other:

Maximum file name length


File name is 45 characters in length:

Reject entire file.

No batch created in DBs.


'System Message 569: Unable to open file V:\TransAction Import\long_file_name_16_901234567890123456789012345.dt.

N/A




Solomon Transaction Import Release Notes Page Published: 10/13/2004

Yüklə 309 Kb.

Dostları ilə paylaş:
1   2   3   4   5




Verilənlər bazası müəlliflik hüququ ilə müdafiə olunur ©genderi.org 2024
rəhbərliyinə müraciət

    Ana səhifə
Psixologiya