BIG VC problem - Need Help!!!!!

[Former Member]

Hi all while trying to solve the problem below I now have a major issue. I am now getting a Fatal Error: Fatal error: No Visual Composer Server was found at specified address....

I have looked on the forums and this appears to be quite common however I am not having any luck getting this fixed! I am also slightly concerned as many people are mentioning change to the VC folder in IIS. But our install has nothing in IIS.

I am amazed this has happen as all that has been changed is the logging, an it has had a negitive impace on our VC server!!!

Really need you help!!!

Thanks in advance

(A concerned!

Hi All

I have a query which I am using to arrange data, however I am contantly getting the following error when I try to deploy it to my portal:

Error in compiling Flex application (1). Consult log file for details

I have found a How To.... guide but I still cannot get it working!

I have found this in the log file if it helps:

String literal was not properly terminated

Any help or advice would be great!

My Query is:

Select "RPTDB"."dbo"."SectorSalesByPrdGroup_Summary"."prodgrp" ,

"RPTDB"."dbo"."SectorSalesByPrdGroup_Summary"."sectorcode" ,

"RPTDB"."dbo"."SectorSalesByPrdGroup_Summary"."CurrentSales" ,

"RPTDB"."dbo"."SectorSalesByPrdGroup_Summary"."Sales" ,

"RPTDB"."dbo"."SectorSalesByPrdGroup_Summary"."PreviousSales" ,

"RPTDB"."dbo"."SectorSalesByPrdGroup_Summary"."CurrentGPC" ,

"RPTDB"."dbo"."SectorSalesByPrdGroup_Summary"."GPC" ,

"RPTDB"."dbo"."SectorSalesByPrdGroup_Summary"."PreviousGPC" ,

"RPTDB"."dbo"."SectorSalesByPrdGroup_Summary"."CurrGP" ,

"RPTDB"."dbo"."SectorSalesByPrdGroup_Summary"."YOY" ,

"RPTDB"."dbo"."SectorSalesByPrdGroup_Summary"."PrevGP" ,

"RPTDB"."dbo"."SectorSalesByPrdGroup_Summary"."period"

from "RPTDB"."dbo"."SectorSalesByPrdGroup_Summary"

order by case when "RPTDB"."dbo"."SectorSalesByPrdGroup_Summary"."sectorcode" <> 'Zt' then 0 else 1 end,

"RPTDB"."dbo"."SectorSalesByPrdGroup_Summary"."prodgrp" , "RPTDB"."dbo"."SectorSalesByPrdGroup_Summary"."sectorcode"

Message was edited by: Phil Wade

Message was edited by: Phil Wade

[Former Member · Accepted solution]

Plese refer to note 974494 to reveal the actual compilation error.

[Former Member · Accepted solution]

I have now done this and enabled logging!

However now I am getting a Fatal Error Message:

No Visual Composer Server found at specified address.

Any ideas?

[former_member193545 · Accepted solution]

Hi

You should restart the entire server to correct this.

Jarrod

[Former Member]

In your SQL code you use the single quote character '. When the MXML Flex code is generated the query string is inserted into the Flex source code. This results in a syntax error. To verify go do the Deploy panel and press compile. Search for 'Zt' and you should see a statement like this

function sendBIR1() : Object {
   var request =
   '<Request type="EXECUTE_RELATIONAL" system="BI_JDBC_NVPAL073" 
system_type="SAP_BI_JDBC" 
<Objects type="INPUT"></Objects>
<Objects type="OUTPUT" shape="SET" role="OUTPUT">
<Object id="2" type="SQL"
value="Select "Northwind"."dbo"."Employees"."EmployeeID"  where "Northwind"."dbo"."Employees"."LastName" = 'Smith'"/>
</Objects></Request>';
   VC.DEBUG(2, 'Sent request: '+request);

The ' before Smith ends the MXML string and the compiler expects a ; but gets Smith.

Try using " instead of '.