Problems with code: AERP_80_2017.dbo.PRC_RAP_LiBlerje_Deklarata_TVSH '08/01/2017', '08/31/2017', '01/01/2017', '12/31/2017', 'AERP_80_2016' RRS feed

  • Question

  • I am using a program that is based on sql 2008r2.

    I have a problem because a document is not openning showing me the error:

    "General SQL Server error: Check Messages from sql server

    Error dedected by database DLL"

    I have opened the profile on sql and the error generates this code: 

    AERP_80_2017.dbo.PRC_RAP_LiBlerje_Deklarata_TVSH '08/01/2017', '08/31/2017', '01/01/2017', '12/31/2017', 'AERP_80_2016'

    I am trying to open a document in year 2017 (AERP_80_2017).

    This error is not happening in the year 2016 (AERP_80_2016).

    AERP_80_2016.dbo.PRC_RAP_LiBlerje_Deklarata_TVSH '08/01/2016', '08/31/2016', '01/01/2016', '12/31/2016', '0'

    because I do not have a previous year like AERP_80_2015.

    Does anyone now how to solve this issue?

    Thank you

    Wednesday, August 9, 2017 2:33 PM

All replies

  • So when happens when you running this call from Management Studio:

    AERP_80_2017.dbo.PRC_RAP_LiBlerje_Deklarata_TVSH '08/01/2017', '08/31/2017', '01/01/2017', '12/31/2017', 'AERP_80_2016'

    Most likely this is an application issue that will not be able to assist with here, but you will need to talk to the vendor of the application.

    Wednesday, August 9, 2017 9:25 PM
  • Please pay attention to the forum you choose for posting. The one you chose does not seem to be relevant to your question. Choosing the most appropriate forum will usually help others with the appropriate skill/interest find and respond to your question.

    But it is difficult to understand your issue based on what you posted. It helps to post the complete and exact test of any errors you encounter. Unfortunately my guess is that your application is not properly handling certain situations correctly and giving misleading (or poorly written) error message. You could look into the logic of the stored procedure and debug it yourself. Your best approach is to contact the vendor of your software. 

    BTW - AERP_80_2017.dbo.PRC_RAP_LiBlerje_Deklarata_TVSH is: 

    AERP_80_2017 -- the database name
    dbo  -- schema name
    PRC_RAP_LiBlerje_Deklarata_TVSH -- stored procedure name

    Thursday, August 10, 2017 1:37 AM