Get Data Moving 1
Results 1 to 5 of 5

Thread: Viewing Logs

  1. #1
    Andre is offline Documentation Manager
    Join Date
    Aug 2006
    Posts
    147
    Rep Power
    14

    Viewing Logs

    AIS produces a number of logs that you can use to troubleshoot problems. These logs are:

    • The daemon log is where the daemon logs various activities such as client logins, server process activations, server process terminations, etc. To find the log file of an active AIS daemon use the IRPCD STATUS command.
    • The server process logs are defined per server workspace. Each server process has its own log file (typically using some unique element in the filename such as process ID, instance number or timestamp). To find the specific server process log, search the daemon log for the process ID of the server processs - that line contains the name of the log file for that server.
    • The local process log are defined per binding definition. When AIS is used locally via either ODBC or OLEDB/ADO, a local process log is created. The contents of this log is exactly the same as that of the server process log.


    The contents of the logs varies based on the logging configuration settings:

    • The contents, location and naming of the daemon log are configured in the Daemon Logging tab of the daemon editor in Studio.
    • The contents, location and naming of the server process logs are configured in the Workspace (WS) Logging tab of the daemon editor in Studio. The server process log also contains the log defined in the workspace's binding definition (see below).
    • The contents, location and naming of the local process logs are configured in the environment debug section of the binding definition the process uses (or if the binding used does not have an environment definition, the NAV binding is used).


    Note
    AIS v4.1 introduced log viewing capability in the AIS Studio's Runtime Explorer view. However, this capability has significant overhead on the running server and may actually impact the logs content and operation. For this reason, when troubleshooting server, the user should have access to the server logs where they are produced.
    Last edited by DrorHarari; 10-21-2006 at 09:55 AM.
    To Find Out more About Attunity Technology:
    Attunity
    or:
    Contact Us

  2. #2
    Betty Sullivan is offline Junior Member
    Join Date
    Sep 2006
    Posts
    12
    Rep Power
    0

    logs

    if a developer does not have access to the studio to view logs, are the logs viewable thru the NAV utility ?

    We have been getting the following error message and I am unable to determine the cause of the error and developers are chosing to stop and restart the daemon. At the time this error was generated, our mainframe was running near 100% CPU. Would this create timeouts? Would the timeouts leave incomplete threads that would require us to stop/restart the daemon to refresh or are there other causes that I can find by reviewing the logs ?

    This error was generated in .NET

    Test method AE.Indexing.BusinessComponent.Test.ControlAssignCo mponentTest.RecordLogonIDTest threw exception: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> AE.Framework.Data.ProviderException: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond. ---> Attunity.Data.AisClient.AisException: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond. ---> Attunity.Data.NavApi.Core.NvSQLReconnectException: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond..

  3. #3
    ussupport1 is offline US Support
    Join Date
    Sep 2006
    Posts
    49
    Rep Power
    0

    Viewing logs

    Betty - The feature in Studio for viewing logs is a feature that was not entirely ported and is not the most reliable way of viewing server log files. The best way to view server logs is to use the mainframe utilities that you currently use for viewing active jobs and their log files. There are some third party tools that allow this to be done on a Windows box. But there is some installation and congifuration . You could set up RACF ID's that only allow the SDSF option to choose in thier main ISPF menu that once into SDSF they can only view prefixed attunity jobs. This would be the easiest and quickest way to resolve your answer.
    To Find Out more About Attunity Technology:
    Attunity
    or:
    Contact Us

  4. #4
    Betty Sullivan is offline Junior Member
    Join Date
    Sep 2006
    Posts
    12
    Rep Power
    0

    Attunity logs & return codes

    Can you tell me where to look to find out what -1210 return code means?
    Is this a NAV return code or SQL return code?

    Attunity Server Log (V4.8.2.0, MVS) Started at 2006-10-23T07:41:02
    Licensed by ATTUNITY US on 17-MAR-2006 (003005648)
    Licensed to AMERICAN REPUBLIC INSURANCE CO for DB2,DB2LOGCDCA,DB2MF on *.ARIC.
    COM (MVS)
    CLNT (1180): ; Connecting to 192.168.100.61:4113:tcp:21624
    nvOUT (PROD.AC4820.NAV(QP#SQTXT) 56): CALL USP_WF104_POLICY_RECORD_SAVE(
    3015247, 90254,'AR','PS',' 1076');
    nvOUT (PROD.AC4820.NAV(QP#SQTXT) 56): SELECT * FROM DummyStoredProcRowset
    nvRETURN (PROD.AC4820.NAV(QPSYNON) 1140): -1
    nvRETURN (PROD.AC4820.NAV(DSM#IUNK) 773): -1210
    (Last message occurred 6 times)

  5. #5
    Costi Zaboura is offline World Wide Support Manager
    Join Date
    Aug 2006
    Posts
    300
    Rep Power
    14

    Viewing log files

    Hi
    RC -1210 unsupported property is irrelevant (you see it due to logging level)- so pls ignore it
    To Find Out more About Attunity Technology:
    Attunity
    or:
    Contact Us

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •