Created by user-4b453 on Feb 11, 2022
Purpose (problem description)

The main purpose of this page is to explain how to proceed to resolve a link between a C sharp method and an SQL Server Participating when the case of the table name in the C# method is not similar to the case of the table name in the SQL Server participating

Observed in CAST AIP
Release
Yes/No
8.3.x(error)
8.2.x(error)
8.1.x (error) 
8.0.x (error)
7.3.x(error)
7.2.x(error)
7.0.x(tick)
Observed on RDBMS
RDBMS
Yes/No
Oracle Server(tick)
Microsoft SQL Server(tick)
CSS3(error)
CSS2(error)
CSS1(tick)
Action Plan

If the case table name in the C# method is not similar to the case table name in the SQL Server participating database, then the link will not be resolved.

If the participating database is Case sensitive and if the End User cannot change the case of the table name in the C# source code, then

  1. Restore the KB and observe the result in Enlighten.
  2. Install the participating database in a case insensitive server.
  3. Analyze the participating SQL Server
  4. The #NET job has to be configured as shown below:
    1. In the "Database Server selection" section, check the participating profile:
    2. In the "Target objects" section, check in the display option : "Show and select unsynchronized database":

    3. Run the #NET analysis. The link will be resolved:


  5. If you are not able to solve the issue,along with the case sensitivity of the participating SQL Server, contact CAST Technical Support with the following Relevant Input

Relevant Input

  1. Description of the expectation regarding why the link is expected/wrong according to you
  2. The source code of the two objects.
    • **For C++, also provide preprocessed file resulting of the analysis of the Caller source file (you will need to run an analysis with the caller source file only).
    • **Incase of java, you need to ask for Both files containing objects and 3rd file which is responsible for link between both objects.
  3. A screenshot in Enlighten showing the the objects names, the objects types, the link type between which there is missing link OR wrong link
  4. Sherlock export which will include the Knowledge Base
Notes/comments

 

Related Pages