Thread Info
  • State Not Answered
  • Locked Locked
  • Replies 5 replies
  • Subscribers 28 subscribers
  • Views 524 views
  • Users 0 members are here
Options
Suggested
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Import conf from XG210 v17.5.14 to XG135 v17.5.14

Tsiory HARRY NAIVO RAKOTO

Hi all,

I am trying to import a .tar file to a XG135 V17.5.14 from an another device XG210 V17.5.14 and it doesn't work.

I always have the message " API import fail"

Have you an idea ?

Thank you 



This thread was automatically locked due to age.
Parents
  • 0

    Hello Tsiory,

    Additionally to what Luca mentioned, please check the csc.log for the following line 

    # OPCODE Exited: 'upload_text_import_file' with Status: '500' 

    Are trying to import Web or IPS police?

    Regards,

  • 0 in reply to emmosophos

    Hello,

    I don'it know why nut i cannot go to log viewer

  • 0 in reply to Tsiory HARRY NAIVO RAKOTO

    beside being a paint to use xml export / imports, I would like to know what setting has to be enabled to really see on which item it fails in /log/apiparser.log. Usually this log contains only useless lines of text. Here for example WebFilterExceptions

    Tons of errors when exporting and also when importing the same unmodified file again. But in the end successful.

    The log is useless...:

    export xml file
ERROR     Nov 09 17:53:58 [19152]: JSON element can't be found for Record no:83, dbcolumnname:WebCat.name.
ERROR     Nov 09 17:53:58 [19152]: JSON element can't be found for Record no:83, dbcolumnname:DstIp.ip.
ERROR     Nov 09 17:53:58 [19152]: JSON element can't be found for Record no:84, dbcolumnname:WebCat.name.
ERROR     Nov 09 17:53:58 [19152]: JSON element can't be found for Record no:84, dbcolumnname:SrcIp.ip.
ERROR     Nov 09 17:53:58 [19152]: JSON element can't be found for Record no:84, dbcolumnname:URLRegex.urlregex.
ERROR     Nov 09 17:53:58 [19152]: JSON element can't be found for Record no:85, dbcolumnname:WebCat.name.
ERROR     Nov 09 17:53:58 [19152]: JSON element can't be found for Record no:86, dbcolumnname:WebCat.name.
ERROR     Nov 09 17:53:58 [19152]: JSON element can't be found for Record no:86, dbcolumnname:SrcIp.ip.
ERROR     Nov 09 17:53:58 [19152]: JSON element can't be found for Record no:86, dbcolumnname:DstIp.ip.
ERROR     Nov 09 17:53:58 [19152]: JSON element can't be found for Record no:87, dbcolumnname:WebCat.name.
ERROR     Nov 09 17:53:58 [19152]: JSON element can't be found for Record no:87, dbcolumnname:DstIp.ip.
ERROR     Nov 09 17:53:58 [19152]: JSON element can't be found for Record no:88, dbcolumnname:WebCat.name.
ERROR     Nov 09 17:53:58 [19152]: JSON element can't be found for Record no:88, dbcolumnname:DstIp.ip.
ERROR     Nov 09 17:53:58 [19152]: JSON element can't be found for Record no:89, dbcolumnname:WebCat.name.
ERROR     Nov 09 17:53:58 [19152]: JSON element can't be found for Record no:89, dbcolumnname:DstIp.ip.
ERROR     Nov 09 17:53:58 [19152]: JSON element can't be found for Record no:90, dbcolumnname:WebCat.name.
ERROR     Nov 09 17:53:58 [19152]: JSON element can't be found for Record no:90, dbcolumnname:DstIp.ip.
ERROR     Nov 09 17:53:58 [19152]: JSON element can't be found for Record no:91, dbcolumnname:WebCat.name.
ERROR     Nov 09 17:53:58 [19152]: JSON element can't be found for Record no:91, dbcolumnname:URLRegex.urlregex.
INFO      Nov 09 17:53:58 [19152]: Command:/scripts/apiparser_generate_tar.sh /sdisk/api-1604940838365921.txt /sdisk/API-1604940838365921 /sdisk/resp-1604940838365865.xml /sdisk/API-1604940838365921.tar /sdisk/API-1604940838365921.log 1 status:0

import xml file
MESSAGE   Nov 09 17:56:03 [22360]: ENTITY 'WebFilterException' IMPORT Success
INFO      Nov 09 17:56:03 [22360]: Start Set Handler,Component : WebFilterException
ERROR     Nov 09 17:56:03 [22360]: Key:ISCrEntity is not found in RequestMap File for WebFilterException.
WARNING   Nov 09 17:56:03 [22360]: Can't get the <Add/Update> element from map file, So Mode value is 'Add'.
ERROR     Nov 09 17:56:03 [22360]: Parser Error: xmlvalue for jsonkey="webcategoryid", xmlelement="/WebFilterException/DomainList/WebCategory" cannot be found in request file.
ERROR     Nov 09 17:56:03 [22360]: Parser Error: xmlvalue for jsonkey="srciplist", xmlelement="/WebFilterException/DomainList/SrcIp" cannot be found in request file.
ERROR     Nov 09 17:56:03 [22360]: Parser Error: xmlvalue for jsonkey="dstiplist", xmlelement="/WebFilterException/DomainList/DstIp" cannot be found in request file.
ERROR     Nov 09 17:56:03 [22360]: Flag setting for this opcode is 16.
INFO      Nov 09 17:56:04 [22360]: Opcode response: status:500
WARNING   Nov 09 17:56:04 [22360]: Opcode failed with 'Add' operation. So call opcode with 'Update'.
ERROR     Nov 09 17:56:04 [22360]: Parser Error: xmlvalue for jsonkey="webcategoryid", xmlelement="/WebFilterException/DomainList/WebCategory" cannot be found in request file.
ERROR     Nov 09 17:56:04 [22360]: Parser Error: xmlvalue for jsonkey="srciplist", xmlelement="/WebFilterException/DomainList/SrcIp" cannot be found in request file.
ERROR     Nov 09 17:56:04 [22360]: Parser Error: xmlvalue for jsonkey="dstiplist", xmlelement="/WebFilterException/DomainList/DstIp" cannot be found in request file.
ERROR     Nov 09 17:56:04 [22360]: Flag setting for this opcode is 16.
INFO      Nov 09 17:56:05 [22360]: Opcode response: status:200
INFO      Nov 09 17:56:05 [22360]: Import for this component is done sucessfully!!!INFO      Nov 09 17:56:05 [22360]: End  SET Handler, Status : Success,  Component : WebFilterException, Transaction : , Operation : NONE.
MESSAGE   Nov 09 17:56:05 [22360]: ENTITY 'WebFilterException' IMPORT Success
INFO      Nov 09 17:56:05 [22360]: Start Set Handler,Component : WebFilterException
ERROR     Nov 09 17:56:05 [22360]: Key:ISCrEntity is not found in RequestMap File for WebFilterException.
WARNING   Nov 09 17:56:05 [22360]: Can't get the <Add/Update> element from map file, So Mode value is 'Add'.
ERROR     Nov 09 17:56:05 [22360]: Parser Error: xmlvalue for jsonkey="webcategoryid", xmlelement="/WebFilterException/DomainList/WebCategory" cannot be found in request file.
ERROR     Nov 09 17:56:05 [22360]: Parser Error: xmlvalue for jsonkey="srciplist", xmlelement="/WebFilterException/DomainList/SrcIp" cannot be found in request file.
ERROR     Nov 09 17:56:05 [22360]: Parser Error: xmlvalue for jsonkey="dstiplist", xmlelement="/WebFilterException/DomainList/DstIp" cannot be found in request file.
ERROR     Nov 09 17:56:05 [22360]: Flag setting for this opcode is 16.
INFO      Nov 09 17:56:05 [22360]: Opcode response: status:500
WARNING   Nov 09 17:56:05 [22360]: Opcode failed with 'Add' operation. So call opcode with 'Update'.
ERROR     Nov 09 17:56:05 [22360]: Parser Error: xmlvalue for jsonkey="webcategoryid", xmlelement="/WebFilterException/DomainList/WebCategory" cannot be found in request file.
ERROR     Nov 09 17:56:05 [22360]: Parser Error: xmlvalue for jsonkey="srciplist", xmlelement="/WebFilterException/DomainList/SrcIp" cannot be found in request file.
ERROR     Nov 09 17:56:05 [22360]: Parser Error: xmlvalue for jsonkey="dstiplist", xmlelement="/WebFilterException/DomainList/DstIp" cannot be found in request file.
ERROR     Nov 09 17:56:06 [22360]: Flag setting for this opcode is 16.
...
... waiting ...
... waiting even more...
...
MESSAGE   Nov 09 17:58:56 [22360]: ENTITY 'WebFilterException' IMPORT Success

XG430_WP02_SFOS 18.0.1 MR-1-Build396#

Reply
  • 0 in reply to Tsiory HARRY NAIVO RAKOTO

    beside being a paint to use xml export / imports, I would like to know what setting has to be enabled to really see on which item it fails in /log/apiparser.log. Usually this log contains only useless lines of text. Here for example WebFilterExceptions

    Tons of errors when exporting and also when importing the same unmodified file again. But in the end successful.

    The log is useless...:

    export xml file
ERROR     Nov 09 17:53:58 [19152]: JSON element can't be found for Record no:83, dbcolumnname:WebCat.name.
ERROR     Nov 09 17:53:58 [19152]: JSON element can't be found for Record no:83, dbcolumnname:DstIp.ip.
ERROR     Nov 09 17:53:58 [19152]: JSON element can't be found for Record no:84, dbcolumnname:WebCat.name.
ERROR     Nov 09 17:53:58 [19152]: JSON element can't be found for Record no:84, dbcolumnname:SrcIp.ip.
ERROR     Nov 09 17:53:58 [19152]: JSON element can't be found for Record no:84, dbcolumnname:URLRegex.urlregex.
ERROR     Nov 09 17:53:58 [19152]: JSON element can't be found for Record no:85, dbcolumnname:WebCat.name.
ERROR     Nov 09 17:53:58 [19152]: JSON element can't be found for Record no:86, dbcolumnname:WebCat.name.
ERROR     Nov 09 17:53:58 [19152]: JSON element can't be found for Record no:86, dbcolumnname:SrcIp.ip.
ERROR     Nov 09 17:53:58 [19152]: JSON element can't be found for Record no:86, dbcolumnname:DstIp.ip.
ERROR     Nov 09 17:53:58 [19152]: JSON element can't be found for Record no:87, dbcolumnname:WebCat.name.
ERROR     Nov 09 17:53:58 [19152]: JSON element can't be found for Record no:87, dbcolumnname:DstIp.ip.
ERROR     Nov 09 17:53:58 [19152]: JSON element can't be found for Record no:88, dbcolumnname:WebCat.name.
ERROR     Nov 09 17:53:58 [19152]: JSON element can't be found for Record no:88, dbcolumnname:DstIp.ip.
ERROR     Nov 09 17:53:58 [19152]: JSON element can't be found for Record no:89, dbcolumnname:WebCat.name.
ERROR     Nov 09 17:53:58 [19152]: JSON element can't be found for Record no:89, dbcolumnname:DstIp.ip.
ERROR     Nov 09 17:53:58 [19152]: JSON element can't be found for Record no:90, dbcolumnname:WebCat.name.
ERROR     Nov 09 17:53:58 [19152]: JSON element can't be found for Record no:90, dbcolumnname:DstIp.ip.
ERROR     Nov 09 17:53:58 [19152]: JSON element can't be found for Record no:91, dbcolumnname:WebCat.name.
ERROR     Nov 09 17:53:58 [19152]: JSON element can't be found for Record no:91, dbcolumnname:URLRegex.urlregex.
INFO      Nov 09 17:53:58 [19152]: Command:/scripts/apiparser_generate_tar.sh /sdisk/api-1604940838365921.txt /sdisk/API-1604940838365921 /sdisk/resp-1604940838365865.xml /sdisk/API-1604940838365921.tar /sdisk/API-1604940838365921.log 1 status:0

import xml file
MESSAGE   Nov 09 17:56:03 [22360]: ENTITY 'WebFilterException' IMPORT Success
INFO      Nov 09 17:56:03 [22360]: Start Set Handler,Component : WebFilterException
ERROR     Nov 09 17:56:03 [22360]: Key:ISCrEntity is not found in RequestMap File for WebFilterException.
WARNING   Nov 09 17:56:03 [22360]: Can't get the <Add/Update> element from map file, So Mode value is 'Add'.
ERROR     Nov 09 17:56:03 [22360]: Parser Error: xmlvalue for jsonkey="webcategoryid", xmlelement="/WebFilterException/DomainList/WebCategory" cannot be found in request file.
ERROR     Nov 09 17:56:03 [22360]: Parser Error: xmlvalue for jsonkey="srciplist", xmlelement="/WebFilterException/DomainList/SrcIp" cannot be found in request file.
ERROR     Nov 09 17:56:03 [22360]: Parser Error: xmlvalue for jsonkey="dstiplist", xmlelement="/WebFilterException/DomainList/DstIp" cannot be found in request file.
ERROR     Nov 09 17:56:03 [22360]: Flag setting for this opcode is 16.
INFO      Nov 09 17:56:04 [22360]: Opcode response: status:500
WARNING   Nov 09 17:56:04 [22360]: Opcode failed with 'Add' operation. So call opcode with 'Update'.
ERROR     Nov 09 17:56:04 [22360]: Parser Error: xmlvalue for jsonkey="webcategoryid", xmlelement="/WebFilterException/DomainList/WebCategory" cannot be found in request file.
ERROR     Nov 09 17:56:04 [22360]: Parser Error: xmlvalue for jsonkey="srciplist", xmlelement="/WebFilterException/DomainList/SrcIp" cannot be found in request file.
ERROR     Nov 09 17:56:04 [22360]: Parser Error: xmlvalue for jsonkey="dstiplist", xmlelement="/WebFilterException/DomainList/DstIp" cannot be found in request file.
ERROR     Nov 09 17:56:04 [22360]: Flag setting for this opcode is 16.
INFO      Nov 09 17:56:05 [22360]: Opcode response: status:200
INFO      Nov 09 17:56:05 [22360]: Import for this component is done sucessfully!!!INFO      Nov 09 17:56:05 [22360]: End  SET Handler, Status : Success,  Component : WebFilterException, Transaction : , Operation : NONE.
MESSAGE   Nov 09 17:56:05 [22360]: ENTITY 'WebFilterException' IMPORT Success
INFO      Nov 09 17:56:05 [22360]: Start Set Handler,Component : WebFilterException
ERROR     Nov 09 17:56:05 [22360]: Key:ISCrEntity is not found in RequestMap File for WebFilterException.
WARNING   Nov 09 17:56:05 [22360]: Can't get the <Add/Update> element from map file, So Mode value is 'Add'.
ERROR     Nov 09 17:56:05 [22360]: Parser Error: xmlvalue for jsonkey="webcategoryid", xmlelement="/WebFilterException/DomainList/WebCategory" cannot be found in request file.
ERROR     Nov 09 17:56:05 [22360]: Parser Error: xmlvalue for jsonkey="srciplist", xmlelement="/WebFilterException/DomainList/SrcIp" cannot be found in request file.
ERROR     Nov 09 17:56:05 [22360]: Parser Error: xmlvalue for jsonkey="dstiplist", xmlelement="/WebFilterException/DomainList/DstIp" cannot be found in request file.
ERROR     Nov 09 17:56:05 [22360]: Flag setting for this opcode is 16.
INFO      Nov 09 17:56:05 [22360]: Opcode response: status:500
WARNING   Nov 09 17:56:05 [22360]: Opcode failed with 'Add' operation. So call opcode with 'Update'.
ERROR     Nov 09 17:56:05 [22360]: Parser Error: xmlvalue for jsonkey="webcategoryid", xmlelement="/WebFilterException/DomainList/WebCategory" cannot be found in request file.
ERROR     Nov 09 17:56:05 [22360]: Parser Error: xmlvalue for jsonkey="srciplist", xmlelement="/WebFilterException/DomainList/SrcIp" cannot be found in request file.
ERROR     Nov 09 17:56:05 [22360]: Parser Error: xmlvalue for jsonkey="dstiplist", xmlelement="/WebFilterException/DomainList/DstIp" cannot be found in request file.
ERROR     Nov 09 17:56:06 [22360]: Flag setting for this opcode is 16.
...
... waiting ...
... waiting even more...
...
MESSAGE   Nov 09 17:58:56 [22360]: ENTITY 'WebFilterException' IMPORT Success

XG430_WP02_SFOS 18.0.1 MR-1-Build396#

Children
No Data