unable to Validate/Activate Calculation Veiw

[Former Member]

Dear frz,

While validating/activating the Cal.View am getting the below IO Exception. Could some one help to resolve the issue.

Script:

BEGIN

sel1 = SELECT ARTICLE_ID,CATEGORY  from "ONLINEB1"."ARTICLE_LOOKUP" ;

sel2 = SELECT ARTICLE_ID,SHOP_ID,AMOUNT_SOLD,QUANTITY_SOLD FROM "ONLINEB1"."SHOP_FACTS";

joinvar = SELECT t1.ARTICLE_ID,t1.category,t2.shop_id,t2.amount_sold,t2.quantity_sold

           FROM :sel1 AS t1 

           LEFT :sel2 AS t2

           ON

           t1.article_id = t2.article_id ;

            var_out = CE_PROJECTION (:joinvar, ["CATEGORY","AMOUNT_SOLD","QUANTITY_SOLD"]);

END /********* End Procedure Script ************/

Error Message:

Message :

          com.sap.ndb.studio.sdk.resource.base.exception.ResourceException: java.io.IOException: Error loading object, refer to Repository Log for more information: java.io.IOException: com.sap.ndb.studio.sdk.resource.base.exception.ResourceException: java.io.IOException: Error loading object, refer to Repository Log for more information: java.io.IOException: com.sap.ndb.studio.sdk.resource.base.exception.ResourceException: java.io.IOException: Error loading object, refer to Repository Log for more information

com.sap.ndb.studio.sdk.resource.base.exception.ResourceException: java.io.IOException: com.sap.ndb.studio.sdk.resource.base.exception.ResourceException: java.io.IOException: Error loading object, refer to Repository Log for more information

          at com.sap.ndb.studio.sdk.resource.repository.core.impl.MDResourceController.getModelObject(MDResourceController.java:170)

          at com.sap.ndb.studio.sdk.resource.repository.core.impl.AbstractResourceController.validate(AbstractResourceController.java:1336)

          at com.sap.ndb.studio.sdk.resource.repository.core.impl.ResourceManager.validateAll(ResourceManager.java:1442)

          at com.sap.ndb.studio.modeler.job.type.validate.ValidateJob.validateObjects(ValidateJob.java:88)

          at com.sap.ndb.studio.modeler.job.type.validate.ValidateJob.run(ValidateJob.java:66)

          at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)

Caused by: java.io.IOException: com.sap.ndb.studio.sdk.resource.base.exception.ResourceException: java.io.IOException: Error loading object, refer to Repository Log for more information

          at com.sap.ndb.studio.sdk.resource.repository.core.impl.AbstractResourceController.load(AbstractResourceController.java:608)

          at com.sap.ndb.studio.sdk.resource.repository.core.impl.MDResourceController.load(MDResourceController.java:647)

          at com.sap.ndb.studio.sdk.resource.repository.core.impl.MDResourceController.getModelObject(MDResourceController.java:167)

          ... 5 more

Caused by: com.sap.ndb.studio.sdk.resource.base.exception.ResourceException: java.io.IOException: Error loading object, refer to Repository Log for more information

          at com.sap.ndb.studio.sdk.resource.repository.core.impl.MDResourceController.deserializeRepositoryFile(MDResourceController.java:638)

          at com.sap.ndb.studio.sdk.resource.repository.core.impl.AbstractResourceController.load(AbstractResourceController.java:601)

          ... 7 more

Caused by: java.io.IOException: Error loading object, refer to Repository Log for more information

          at com.sap.ndb.studio.sdk.resource.base.DBRepositoryURIConverter.createInputStream(DBRepositoryURIConverter.java:130)

          at com.sap.ndb.studio.sdk.resource.base.DBRepositoryURIConverter.createInputStream(DBRepositoryURIConverter.java:65)

          at com.sap.ndb.studio.sdk.resource.repository.MDResource.load(MDResource.java:156)

          at com.sap.ndb.studio.sdk.resource.repository.core.impl.MDResourceController.loadMainResource(MDResourceController.java:264)

          at com.sap.ndb.studio.sdk.resource.repository.core.impl.MDResourceController.deserializeRepositoryFile(MDResourceController.java:635)

          ... 8 more

Krishna

[Former Member]

Hi Krishna,

You maybe using Cloudshare environment, right? if so could you open windows command and exec netstat to check you connect HANA server? the port is maybe 30015.

If it is ok, you open SQL console to exec below sql one by one.

SELECT ARTICLE_ID,CATEGORY  from "ONLINEB1"."ARTICLE_LOOKUP" ;

SELECT ARTICLE_ID,SHOP_ID,AMOUNT_SOLD,QUANTITY_SOLD FROM "ONLINEB1"."SHOP_FACTS";

SELECT t1.ARTICLE_ID,t1.category,t2.shop_id,t2.amount_sold,t2.quantity_sold

           FROM "ONLINEB1"."ARTICLE_LOOKUP" AS t1

           LEFT OUTER JOIN "ONLINEB1"."SHOP_FACTS" AS t2

           ON  t1.article_id = t2.article_id ;

Check It is ok or not above sql statement,  if it is ok, you can test sample sql script for calculation view.

begin

var_out = select now() as "TimeStamp", 1 as "Num" from dummy;

end

you need to define two output parameter for var_out table type, TimeStamp VARCHAR(30)/Num Tinyint.

finally, you define "TimeStamp" as attribute and "Num" as measure for calculation view, and save and active your calculation view.

If the test is ok, you can exec your script again to save and activate your calculation view.

Hope this can help you.

Regards

Jerry

[Former Member]

Dear Basha,

I just tried with the simple statement as below....but still am getting the same error..

I think is there is som issue with the Java Installation at server side...am i correct????

Statement:

var_out = ce_column_table ("ONLINEB1"."ARTICLE_LOOKUP",["ARTICLE_ID","SALE_PRICE"]);

added the out parameters also.

Regards,

Krishna

[Former Member]

Hi Krishna,

Can you try to activate other objects and check whether you are getting same error?

Please check whether your studio and DB are in same version.

In calculation views, check the filed length in output parameter are same as the original fields length in tables.

Regards,

Venkat

[rindia]

Hi Krishna,

Are you using SAP HANA Development perspective?

Try using Modeler prospective and if you get the error please attach screenshot.

Also check whether your tables are Column store.

Regards

Raj

[Former Member]

Hi Krishna,

  As per the SAP, do not mix the SQL and CE Scripts.

Please check the below points in your side.

1. Please make sure that ARTICLE_LOOKUP& SHOP_FACTS tables  should exists in your        schema(ONLINEB1)

2. SELECT t1.ARTICLE_ID,t1.category,t2.shop_id,t2.amount_sold,t2.quantity_sold

           FROM :sel1 AS t1

          LEFT OUTER JOIN   :sel2 AS t2

           ON  t1.article_id = t2.article_id ;

3. Add the "CATEGORY","AMOUNT_SOLD","QUANTITY_SOLD"  to Output parameter(var_out)

Thanks

Basha