Trade Smart Online

[SmartTradeOnline]

Hi STO,
When i try to generate ECN in back office it throws error ,i tried in firefox and IE 9.why this error shows up ,am i missing something?
regards,
m prakash

Please use IE only. Also, please let us know the error you are getting.

 

[mprakash1972]

Hi sto,
when i try to generate ECN i got the following error.
regards,
m prakash
Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'from'.

The error occurred in C:\JRun4\servers\cfusion\cfusion-ear\cfusion-war\Client\Text_Reports\Trading\FO\PrePrintedContractQuery.cfm: line 73
Called from C:\JRun4\servers\cfusion\cfusion-ear\cfusion-war\Client\Text_Reports\Trading\FO\NSE_FNOContractHTML.cfm: line 88
Called from C:\JRun4\servers\cfusion\cfusion-ear\cfusion-war\Client\Text_Reports\Trading\FO\NSE_FNOContractHTML.cfm: line 80
Called from C:\JRun4\servers\cfusion\cfusion-ear\cfusion-war\Client\Text_Reports\Trading\FO\NSE_FNOContractHTML.cfm: line 11
Called from C:\JRun4\servers\cfusion\cfusion-ear\cfusion-war\Client\Text_Reports\Trading\FO\NSE_FNOContractHTML.cfm: line 10
Called from C:\JRun4\servers\cfusion\cfusion-ear\cfusion-war\Client\Text_Reports\Trading\FO\NSE_FNOContractHTML.cfm: line 1
Called from C:\JRun4\servers\cfusion\cfusion-ear\cfusion-war\Client\Text_Reports\Trading\FO\PrePrintedContractQuery.cfm: line 73
Called from C:\JRun4\servers\cfusion\cfusion-ear\cfusion-war\Client\Text_Reports\Trading\FO\NSE_FNOContractHTML.cfm: line 88
Called from C:\JRun4\servers\cfusion\cfusion-ear\cfusion-war\Client\Text_Reports\Trading\FO\NSE_FNOContractHTML.cfm: line 80
Called from C:\JRun4\servers\cfusion\cfusion-ear\cfusion-war\Client\Text_Reports\Trading\FO\NSE_FNOContractHTML.cfm: line 11
Called from C:\JRun4\servers\cfusion\cfusion-ear\cfusion-war\Client\Text_Reports\Trading\FO\NSE_FNOContractHTML.cfm: line 10
Called from C:\JRun4\servers\cfusion\cfusion-ear\cfusion-war\Client\Text_Reports\Trading\FO\NSE_FNOContractHTML.cfm: line 1

71 : and a.COMPANY_CODE = '#Trim(Ucase(cocd))#'
72 : and CONVERT(DATETIME, TRADE_DATE, 103) = CONVERT(DATETIME, '#TRADE_DATE#', 103)
73 : and a.Client_ID = '#client_id#'
74 : and a.Expense_Type = 'SCH'
75 : and b.SHOWINCONTRACT = 'Y'



--------------------------------------------------------------------------------

SQL Select SUM(round( ( a.Debit - a.Credit ) , b.ControlName from Client_Expenses a , Control_Master b Where a.COMPANY_CODE = b.COMPANY_CODE and a.ExpenseAccount = b.ControlAccount and a.COMPANY_CODE = 'NSE_FNO' and CONVERT(DATETIME, TRADE_DATE, 103) = CONVERT(DATETIME, '18/03/2013', 103) and a.Client_ID = 'YTNM02 ' and a.Expense_Type = 'SCH' and b.SHOWINCONTRACT = 'Y'
DATASOURCE capsfo
VENDORERRORCODE 156
SQLSTATE HY000

Please try the following:
Check the ColdFusion documentation to verify that you are using the correct syntax.
Search the Knowledge Base to find a solution to your problem.


Browser Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.1; Trident/6.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; .NET4.0C)
Remote Address 192.168.26.1
Referrer http://backoffice.vnsfin.com:85/Client/ProcessData/EncContract.cfm
Date/Time 20-Mar-13 07:21 PM

Stack Trace (click to expand)
at cfPrePrintedContractQuery2ecfm1769603754.runPage(C:\JRun4\servers\cfusion\cfusion-ear\cfusion-war\Client\Text_Reports\Trading\FO\PrePrintedContractQuery.cfm:73) at cfNSE_FNOContractHTML2ecfm1701174797._factor6(C:\JRun4\servers\cfusion\cfusion-ear\cfusion-war\Client\Text_Reports\Trading\FO\NSE_FNOContractHTML.cfm:88) at cfNSE_FNOContractHTML2ecfm1701174797._factor14(C:\JRun4\servers\cfusion\cfusion-ear\cfusion-war\Client\Text_Reports\Trading\FO\NSE_FNOContractHTML.cfm:80) at cfNSE_FNOContractHTML2ecfm1701174797._factor15(C:\JRun4\servers\cfusion\cfusion-ear\cfusion-war\Client\Text_Reports\Trading\FO\NSE_FNOContractHTML.cfm:11) at cfNSE_FNOContractHTML2ecfm1701174797._factor16(C:\JRun4\servers\cfusion\cfusion-ear\cfusion-war\Client\Text_Reports\Trading\FO\NSE_FNOContractHTML.cfm:10) at cfNSE_FNOContractHTML2ecfm1701174797.runPage(C:\JRun4\servers\cfusion\cfusion-ear\cfusion-war\Client\Text_Reports\Trading\FO\NSE_FNOContractHTML.cfm:1) at cfPrePrintedContractQuery2ecfm1769603754.runPage(C:\JRun4\servers\cfusion\cfusion-ear\cfusion-war\Client\Text_Reports\Trading\FO\PrePrintedContractQuery.cfm:73) at cfNSE_FNOContractHTML2ecfm1701174797._factor6(C:\JRun4\servers\cfusion\cfusion-ear\cfusion-war\Client\Text_Reports\Trading\FO\NSE_FNOContractHTML.cfm:88) at cfNSE_FNOContractHTML2ecfm1701174797._factor14(C:\JRun4\servers\cfusion\cfusion-ear\cfusion-war\Client\Text_Reports\Trading\FO\NSE_FNOContractHTML.cfm:80) at cfNSE_FNOContractHTML2ecfm1701174797._factor15(C:\JRun4\servers\cfusion\cfusion-ear\cfusion-war\Client\Text_Reports\Trading\FO\NSE_FNOContractHTML.cfm:11) at cfNSE_FNOContractHTML2ecfm1701174797._factor16(C:\JRun4\servers\cfusion\cfusion-ear\cfusion-war\Client\Text_Reports\Trading\FO\NSE_FNOContractHTML.cfm:10) at cfNSE_FNOContractHTML2ecfm1701174797.runPage(C:\JRun4\servers\cfusion\cfusion-ear\cfusion-war\Client\Text_Reports\Trading\FO\NSE_FNOContractHTML.cfm:1)


java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'from'.
at macromedia.jdbc.base.BaseExceptions.createException(Unknown Source)
at macromedia.jdbc.base.BaseExceptions.getException(Unknown Source)
at macromedia.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)
at macromedia.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)
at macromedia.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)
at macromedia.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown Source)
at macromedia.jdbc.base.BaseStatement.commonTransitionToState(Unknown Source)
at macromedia.jdbc.base.BaseStatement.postImplExecute(Unknown Source)
at macromedia.jdbc.base.BaseStatement.commonExecute(Unknown Source)
at macromedia.jdbc.base.BaseStatement.executeInternal(Unknown Source)
at macromedia.jdbc.base.BaseStatement.execute(Unknown Source)
at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:212)
at coldfusion.sql.Executive.executeQuery(Executive.java:705)
at coldfusion.sql.Executive.executeQuery(Executive.java:638)
at coldfusion.sql.Executive.executeQuery(Executive.java:599)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:236)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:498)
at cfPrePrintedContractQuery2ecfm1769603754.runPage(C:\JRun4\servers\cfusion\cfusion-ear\cfusion-war\Client\Text_Reports\Trading\FO\PrePrintedContractQuery.cfm:73)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:343)
at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1908)
at cfNSE_FNOContractHTML2ecfm1701174797._factor6(C:\JRun4\servers\cfusion\cfusion-ear\cfusion-war\Client\Text_Reports\Trading\FO\NSE_FNOContractHTML.cfm:88)
at cfNSE_FNOContractHTML2ecfm1701174797._factor14(C:\JRun4\servers\cfusion\cfusion-ear\cfusion-war\Client\Text_Reports\Trading\FO\NSE_FNOContractHTML.cfm:80)
at cfNSE_FNOContractHTML2ecfm1701174797._factor15(C:\JRun4\servers\cfusion\cfusion-ear\cfusion-war\Client\Text_Reports\Trading\FO\NSE_FNOContractHTML.cfm:11)
at cfNSE_FNOContractHTML2ecfm1701174797._factor16(C:\JRun4\servers\cfusion\cfusion-ear\cfusion-war\Client\Text_Reports\Trading\FO\NSE_FNOContractHTML.cfm:10)
at cfNSE_FNOContractHTML2ecfm1701174797.runPage(C:\JRun4\servers\cfusion\cfusion-ear\cfusion-war\Client\Text_Reports\Trading\FO\NSE_FNOContractHTML.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:343)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:210)
at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:51)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:86)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:50)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.CfmServlet.service(CfmServlet.java:105)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:78)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:257)
at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527)
at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:204)
at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:457)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)

 

[timepass]

Ok. Go to params as in the image below and select merge companies as yes
..........
This is how you'll see it
................
Moreover, P&L report for FNO is being added. Should be there by tomorrow morning.

Got it. Thanks. I can see what is perhaps datewise, billwise listing.

Next, in the same screen, "Excel" option is not working. So I can not export it to excel (or .csv or .txt or any other format) and work on it as per my wish.

 

[SmartTradeOnline]

Hi STO,
When i try to generate ECN in back office it throws error ,i tried in firefox and IE 9.why this error shows up ,am i missing something?
regards,
m prakash

Hello mprakash172,
Thanks for letting us know. We are looking into the same and will update you once it is fixed.

 

[SmartTradeOnline]

Got it. Thanks. I can see what is perhaps datewise, billwise listing.

Next, in the same screen, "Excel" option is not working. So I can not export it to excel (or .csv or .txt or any other format) and work on it as per my wish.

Hello timepass,
We just checked the "Excel" functionality and it is working on our side.

When you click on "Excel", you will get an alert blocking the Activex to run.
1. Make sure you do not have Activex disabled
2. Make sure you agree to run it when you get the above mentioned alert.
3. Last but not the least, make sure you have Excel installed and not Open office

 

[SmartTradeOnline]

Hi STO,
When i try to generate ECN in back office it throws error ,i tried in firefox and IE 9.why this error shows up ,am i missing something?
regards,
m prakash

mprakash1972,
Please check again and let us know if you are still facing the same issues with contract note generation for FNO.

Please make sure to use IE only.

 

[XUV-500]

I am using NOW 1.8
Why i am not seeing SL-L and SL-M differently?

 

[mprakash1972]

Dear STO,
just now checked in backoffice ECN contract file generation works like a charm.thanks for the effort to rectify it.your customer care is excellent.job welldone.
regards,
m prakash

 

[soft_trader]

What is the meaning of this?

 

[SmartTradeOnline]

What is the meaning of this?

Will check with NOW. Are you using Windows XP or Windows 7?