@Sachith, please check this out. Guess we haven't packed these scripts with the distribution. But I'd the idea, we should be getting these automatically from the kernel though.
Anyways, for now, we can copy these scripts from another product to the required location and get it to work. Cheers, Anjana. On Fri, Feb 12, 2016 at 11:41 AM, Shashika Ubhayaratne <[email protected]> wrote: > <adding DAS members to the loop> > > I was able to reproduce this issue by just starting DAS 301 fresh pack > with -Dsetup. > > This pack does not contain dbscripts/Identity folder and scripts. > > Regards, > Shashika > > > Shashika Ubhayaratne > Associate Technical Lead - QA > WSO2 Inc: http://www.wso2.com/ > Mobile: *+94773383831* > > On Fri, Feb 12, 2016 at 2:53 AM, Udara Rathnayake <[email protected]> wrote: > >> Hi, >> >> I have configured a DAS 3.0.1 instance with mssql. Added registry and >> usermgt datasource configurations to the master-datasources.xml and default >> carbon datasource is untouched(pointing to the default h2). >> >> Then configured analytics-datasources.xml by pointing to MSSQL DBs. >> >> While starting DAS node with -Dsetup noticed following[1]. >> >> Then just to verify, I have started(-Dsetup) a fresh DAS pack after >> clearing wso2das-3.0.1/repository/database directory. Noticed the same >> error and we don't have a sql script under the highlighted directory. >> >> Do we need to configure a separate identity DB and modify identity.xml >> datasource config? >> >> <DataSource> >>> <!-- Include a data source name (jndiConfigName) from the >>> set of data >>> sources defined in master-datasources.xml --> >>> <Name>jdbc/WSO2CarbonDB</Name> >>> </DataSource> >>> >> >> >> [1] >> >> [2016-02-11 15:40:51,306] ERROR >>> {org.wso2.carbon.identity.core.internal.IdentityCoreServiceComponent} - >>> Error occurred while populating identity configuration properties >>> org.wso2.carbon.identity.base.IdentityRuntimeException: Error occurred >>> while executing SQL script for creating identity database >>> at >>> org.wso2.carbon.identity.base.IdentityRuntimeException.error(IdentityRuntimeException.java:162) >>> at >>> org.wso2.carbon.identity.core.persistence.IdentityDBInitializer.executeSQLScript(IdentityDBInitializer.java:273) >>> at >>> org.wso2.carbon.identity.core.persistence.IdentityDBInitializer.createIdentityDatabase(IdentityDBInitializer.java:141) >>> at >>> org.wso2.carbon.identity.core.persistence.JDBCPersistenceManager.initializeDatabase(JDBCPersistenceManager.java:112) >>> at >>> org.wso2.carbon.identity.core.internal.IdentityCoreServiceComponent.activate(IdentityCoreServiceComponent.java:101) >>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >>> at >>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) >>> at >>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >>> at java.lang.reflect.Method.invoke(Method.java:497) >>> at >>> org.eclipse.equinox.internal.ds.model.ServiceComponent.activate(ServiceComponent.java:260) >>> at >>> org.eclipse.equinox.internal.ds.model.ServiceComponentProp.activate(ServiceComponentProp.java:146) >>> at >>> org.eclipse.equinox.internal.ds.model.ServiceComponentProp.build(ServiceComponentProp.java:345) >>> at >>> org.eclipse.equinox.internal.ds.InstanceProcess.buildComponent(InstanceProcess.java:620) >>> at >>> org.eclipse.equinox.internal.ds.InstanceProcess.buildComponents(InstanceProcess.java:197) >>> at >>> org.eclipse.equinox.internal.ds.Resolver.getEligible(Resolver.java:343) >>> at >>> org.eclipse.equinox.internal.ds.SCRManager.serviceChanged(SCRManager.java:222) >>> at >>> org.eclipse.osgi.internal.serviceregistry.FilteredServiceListener.serviceChanged(FilteredServiceListener.java:107) >>> at >>> org.eclipse.osgi.framework.internal.core.BundleContextImpl.dispatchEvent(BundleContextImpl.java:861) >>> at >>> org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:230) >>> at >>> org.eclipse.osgi.framework.eventmgr.ListenerQueue.dispatchEventSynchronous(ListenerQueue.java:148) >>> at >>> org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEventPrivileged(ServiceRegistry.java:819) >>> at >>> org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEvent(ServiceRegistry.java:771) >>> at >>> org.eclipse.osgi.internal.serviceregistry.ServiceRegistrationImpl.register(ServiceRegistrationImpl.java:130) >>> at >>> org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.registerService(ServiceRegistry.java:214) >>> at >>> org.eclipse.osgi.framework.internal.core.BundleContextImpl.registerService(BundleContextImpl.java:433) >>> at >>> org.eclipse.osgi.framework.internal.core.BundleContextImpl.registerService(BundleContextImpl.java:451) >>> at >>> org.wso2.carbon.core.init.CarbonServerManager.initializeCarbon(CarbonServerManager.java:514) >>> at >>> org.wso2.carbon.core.init.CarbonServerManager.removePendingItem(CarbonServerManager.java:290) >>> at >>> org.wso2.carbon.core.init.PreAxis2ConfigItemListener.bundleChanged(PreAxis2ConfigItemListener.java:118) >>> at >>> org.eclipse.osgi.framework.internal.core.BundleContextImpl.dispatchEvent(BundleContextImpl.java:847) >>> at >>> org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:230) >>> at >>> org.eclipse.osgi.framework.eventmgr.EventManager$EventThread.run(EventManager.java:340) >>> *Caused by: java.io.FileNotFoundException: >>> /carbon/wso2/das/wso2das-3.0.1/dbscripts/identity/h2.sql* (No such file >>> or directory) >>> at java.io.FileInputStream.open0(Native Method) >>> at java.io.FileInputStream.open(FileInputStream.java:195) >>> at java.io.FileInputStream.<init>(FileInputStream.java:138) >>> at java.io.FileInputStream.<init>(FileInputStream.java:93) >>> at >>> org.wso2.carbon.identity.core.persistence.IdentityDBInitializer.executeSQLScript(IdentityDBInitializer.java:235) >>> ... 30 more >>> >> >> >> -- >> Regards, >> UdaraR >> >> _______________________________________________ >> Dev mailing list >> [email protected] >> http://wso2.org/cgi-bin/mailman/listinfo/dev >> >> > -- *Anjana Fernando* Senior Technical Lead WSO2 Inc. | http://wso2.com lean . enterprise . middleware
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
