I think this can be achieved. When you create a copy of your production system, you can select which data you want to copy- you can select no for users and application data.You can use SAP TEST DATA Migration Server TDMS, to transfer limited data to test instance however it involves extra cost and not recommended until it is really required. Refer this link to know more on TDMS:SAP TDMSYou can keep both the instance- Prod and Test synchronized by using Transport Management System TMS where you can schedule transport to load data to training instance. With use of Change ... Read More

Note that com.sap.conn.jco.JCo can be used as an alternative of com.sap.mw.jco and exists in sapjco.jar. Classes in sapjco.jar files is also different. You can check this link for more details:com.sap.conn.jco.JCo 

Note that to use xsaccess file it without credentials, you have to create xssqlcc file. xsaccess file is used to define who all are authorized to access the content exposed by a SAP HANA XS application package and what content should be displayed as per access.Check out this tread for more details:xsodata service without authentication

In SAP, there is a file intro.html that contains detailed instructions on installation of JCo3 on different Operating Systems.Following are the instructions:To install JCo for Windows unzip the appropriate distribution package into an arbitrary directory {sapjco3-install-path}.Note: Do not copy the sapjco3.dll neither into the {windows-dir}\system32 nor into the {windows-dir}\SysWOW64 directory. This will break the operability of other JCo versions that are already installed on the same system. Furthermore you would risk that the current installation also would not work anymore, if the sapjco3.dll gets replaced in the respective Windows system directory in the future.Then add {sapjco3-install-path} to the PATH environment ... Read More

Note that Xcode-maven-plugin is not compatible with maven 3.1. You have to downgrade to lower version Maven 3.0.x.

Try using ADD_SECONDS function as below:SELECT ADD_SECONDS (TO_TIMESTAMP('2017-07-15 02:17:15'), 0.1) FROM TESTThis will add seconds as fraction value as requested. Below is syntax and example:ADD_SECONDS SyntaxADD_SECONDS (t, n)DescriptionComputes the time t plus n seconds.Example:SELECT ADD_SECONDS (TO_TIMESTAMP ('2012-01-01 23:30:45'), 60*30) "add seconds" FROM DUMMY; add seconds2012-01-02 00:00:45.0To know more about ADD_SECONDS function, you can also refer this link:datetime function in SAP HANATo know more about SQL functions in SAP HANA system, you can also refer our HANA tutorial:SAP HANA SQL FunctionsRead More

This normally happens when you have incorrect configuration in synchronization profile. You have to check if stream parameters are set correctly, etc.

I think you need to setup filtering in Record Selection formula. Navigate to this path to open Record Selection Formula:Report → Selection Formula → RecordThis will open a new window where you can pass your condition and rerun the report.To know more about Record Selection Formula, you can refer this link:1217147 - Crystal Reports Record Selection Formula change order when modifying it via the Select Expert.SAP Knowledge Base 1217147

After you set objRfcFunc, try this before you call this and this will include these parameters.With objRfcFunc.tables("funcloc_ra")    If .RowCount < 1 Then .Rows.Add    .cell(1, 1) = "I"    .cell(1, 2) = "EQ"    .cell(1, 3) = "Your Func Loc"End With

I think this can be resolved by navigating to Format Editor tab. You have to check "Can Grow", and deselect the Keep Object together in the subreport as shown in below.