Embedded Files
Talkdelta RM Installation Process
Talkdelta RM Installation Process
RM Installation:
RM Installation:
1) Extract TalkdeltaRM rar file in your D drive.
1) Extract TalkdeltaRM rar file in your D drive.
1. Talk delta RM setup folder>Copy DLL folder > paste it in your C drive> copy all
the files in the DLL folder except DLL_Reg and paste it in> windows> System/system32
Run DLL_Reg in C drive. (Run as admin)
2. Talk delta RM setup folder(Target folder)>OCX folder> Copy all the files except Register
file >paste it in c drive>windows> system/system32.
3. Create a new folder in your target folder and name it DATA.[Ddrive>targetfolder> create
a new folder (DATA)]
2) Create a new Database:
2) Create a new Database:
1. Open SQL Management Studio (SQL Server 2008 R2-Express Edition)>Database>New
database> Name it as TDRM>in data files> give the path of the data folder
from the target folder. [Refer to the picture below]
3) Backup Restore:
3) Backup Restore:
1. Target folder> TDRM_Blank.rar file> Extract here.
2. Open SQL management studio>Database>right click on TDRM> task>Restore>database> select
from device >give the path of bkp_TDRM_BLank.bak (blank data created in target folder)> select
the backup sets to restore > select the file mentioned.
3. Select page>Option> select Overwrite the existing database> select the path for mdf file
and log file>D drive>target folder>data> OK>You’ll see backup restore successful>OK.
[Refer the picture mentioned below]
4) DSN Creation:
4) DSN Creation:
1. Control panel> system and security> administrative tool> Data sources (ODBC)>Run as admin.
2. Data sources>system DSN>ADD>SQL server>Finish > enter name as TDRM>which sql server do you want to connect > select server name.
3. >Enter login id and password> Next> select change the default database> select TDRM> Next> Finish.
4. Test data source> test completed> OK.
5) Register RM:
5) Register RM:
1. Check the settings file in target folder.[ D drive> target folder>settings file> make the changes as (Authentication-> SQL server, DS->SQL name, SA->sa and password catalog->database name (TDRM)
2. If any error occurs then check the protocols [ SQL server configuration manager> SQL network configuration> protocol>enable all the mentioned protocols]
3. D drive> target folder> Talk Delta REG RM> Run as
admin>enter the details>Register>Done.
4. Create a shortcut of talk delta RM exe (03/05/2019)
6) Upload tokens:
6) Upload tokens:
1. Now we need to upload the latest contract, security and CD_contract files.[target folder> token upload RM exe>run as admin>upload all 3 files >select the tab (contract/security/CD_contract)> browse the files> upload>close.
7) Upload Notice files:
7) Upload Notice files:
● Note:[You have to start the upload tool every day in the morning start auto upload and do not close the upload tool while talkdelta rm exe is in use]
1. Now we need to upload notice files (ex: trade cm/trade fo)
2. Talk delta RM setup folder>talk delta rm upload tool>run as admin>menu>upload>text file upload.
3. Select the file path>select the file configuration>add to list>save settings and upload.
4. SQL server settings>Initial catalog (Database name)>Log file name( Database name_log).
5. Refer the picture:
8) SQL Selection:
8) SQL Selection:
1. We need to select the SQL version. [target folder> talk delta RM upload tool>run as admin> settings> systemsetting>select SQL version> SQL2008.] [Let the expiry date be default]
- How to map users
9) Map the users:
9) Map the users:
1. Ask the client for CTCL users list. The provided list should be properly aligned.
2. Create a new excel sheet in the given format below.
| SR_No | UserGroup | User_name | User_code | Neat_id | CTCL_code |
10) Let's try to understand how to map users with an example:
10) Let's try to understand how to map users with an example:
1. Suppose the ctcl user list is as given in below picture: picture1
2. Create a new excel sheet in the given format and enter the details as shown in
the picture : picture 2
3. We will enter the user code for both CM and FO in one file. First
we will enter user code for FO and just below we will enter user
code for CM as shown in picture 3 .
Picture 1
Picture 2
Picture3: Here you can see that the names of users are repeated after sr no 5. I.e from sr no 1to5 is ctcl code for FO and sr no 6to10 is ctcl code for CM.
11) Now we will cross verify the ctcl code in Trade CM and trade FO:
11) Now we will cross verify the ctcl code in Trade CM and trade FO:
1. For this, we need to open the trade files of CM/FO in excel and
correct it in a proper format.
2. Now we will copy one ctcl code and search for it in trade files.
[Let’s understand this with an example]
3. Example: select the ctcl code of FO of user Mital (Refer picture2)
and open the excel sheet of trade file(FO) and try to find the ctcl
code in excel sheet. Copy the corresponding neat id and paste it
in ctcl user list we created. [Refer picture 3]
4. Now we need to create user code for ctcl user in ctcl user list.
[ In ctcl users list in user code column we will merge neat id and
ctcl code. For eg: we will use the formula =E1&f1 and tab the
user code will be created] refer the picture mentioned below.
12) How to take backup in RM:
12) How to take backup in RM:
1. Open SQL Management studio
2. Click on Databases > select TDRM (right-click on tdrm> click on task>click on backup.
3. Here click on Remove > click on add> select the file path where you want to back up the file.
4. Save the file with .bak extension (TDRM09122019.bak) click on ok
5. Click on ok, it might take a while
6. You will see a popup, The backup of TDRM completed successfully.
7. Refer the picture:
RM Troubleshoot
RM Troubleshoot
1) Live rate not showing:
1) Live rate not showing:
1. Check broadcast settings and general settings in system settings.
2. Check contract/security files. Update tokens.
3. Map the tokens. Check whether the tokens are available in Live bhavcopy.
2) Day Reduce:
2) Day Reduce:
1. Same as talk delta single user. Check the system setting, day reduce settings.
3) Error while uploading notice files: [Refer the picture]
3) Error while uploading notice files: [Refer the picture]
1. Check the date format.
2. RM exe is not compatible with window 10 yet. You may have to request
the client to downgrade their windows.
3. Run sql queries in SQL management studio and try uploading notice files.
4. First execute (delete query) then execute (QryUpdatePortfolioIDEU)
4) 13 type mismatch error:
4) 13 type mismatch error:
1.check your system settings, check your ports.
1.check your system settings, check your ports.
5) LTP not showing:
5) LTP not showing:
1. Check the broadcast settings
2. Upload contract/security files and map the tokens, Run the token updation
exe. Check if tokens are available in Live bhavcopy.
6) Login failed for sa user:
6) Login failed for sa user:
1. Check the settings file in the target folder. Check password (PD),
password should be the same as password set for sa user in sql.
7) Incorrect Span Margin:
7) Incorrect Span Margin:
● Error while registering RM: [Refer the picture] [Note: Always remember to
first take backup/restore in sql and create DSN before registering RM]
1. Always remember to Check the setting files in target folder.[ D drive> target folder> settings file>
make the changes as (Authentication-> SQL server, DS->SQL name, SA->sa and
password catalog-> database name (TDRM)
2. If any error occurs then check the protocols [ SQL server configuration manager> SQL
network configuration> protocol> enable all the mentioned protocols]
3. D drive> target folder> Talk Delta REG RM> Run as
admin>enter the details>Register>Done.
4. Create a shortcut of talk delta RM exe (03/05/2019)
8) file not found: While uploading contract/sec files:
8) file not found: While uploading contract/sec files:
1. File is missing.
2. Check weekly script, schema file, videos folder etc.
9) 383 text property is read only:
9) 383 text property is read only:
Error in database.. Change the database. Or Rereg again.
10) Incorrect values in Var Analysis:
10) Incorrect values in Var Analysis:
check the tokens and live rate.
11) Unsuccessful upload:
11) Unsuccessful upload:
1. Check the file configuration.
12) 381 text property error:
12) 381 text property error:
Run SP.
1. Open Sql management studio.
2. Open Database->TDRM-> Programmability->Stored procedure->Search
Spname(SPsummaryDetailsRiskviewerscriptwise)-> Rename sp as old
3. Now Click on New query-> copy the query given for sp execute and check.
13) How to shrink database in SQL:
13) How to shrink database in SQL:
1. First take backup of Database.
2. Execute the below query: Replace MyDatabase with actual database name (TDRM)
-ALTER DATABASE MyDatabase SET RECOVERY SIMPLE <GO>
-DBCC SHRINKFILE(MyDatabase_log, 5) <GO>
-ALTER DATABASE MyDatabase SET RECOVERY FULL <GO>
14) Cannot open TDRM database:
14) Cannot open TDRM database:
15) Error while uploading data in upload tool:
15) Error while uploading data in upload tool:
1. Check if in system settings sql version is selected.
2. In the Text file upload tab check if the database name is mentioned in the initial catalog.
Page updated
Google Sites
Report abuse