Hi @ismcagdas,
Is it possible to have quick call with you so that we can explain you issue in more details. Please let us know, by when we can connect with your timezone.
Thanks
Hi @ismcagdas,
Please let me know if we can try something related to this issue.Because i need to add that jquery files in our project. Thanks
Hi @musa.demir As i can see there is only one tenant data so could you please describe more how can i use other tenant?
Hi @ismcagdas We are generating query as commandText having "@p0" , "@p1" placeholder, commandType as Text, and passing SqlParameter as params Array. Yes, it is handled in DatabaseHelper.cs file. Please refer below code.
public DbCommand CreateCommand(string commandText, CommandType commandType, params SqlParameter[] parameters) { var command = GetContext().Database.GetDbConnection().CreateCommand();
command.CommandText = commandText;
command.CommandType = commandType;
command.Transaction = GetActiveTransaction();
foreach (var parameter in parameters)
{
command.Parameters.Add(parameter); // from this line it is givinng us exception "The SqlParameterCollection //only accepts non-null SqlParameter type objects, not SqlParameter //objects"
}
return command;
}
Hey after running successfully both the project by default tenantid should 1 and tenantname should be 'Default' but it is setting tenant id null so no for every user it showing me invalid username password
Hi @ismcagdas I am attaching code block of angular.json here
{
"$schema": "./node_modules/@angular/cli/lib/config/schema.json",
"cli": {
"analytics": false
},
"version": 1,
"newProjectRoot": "projects",
"projects": {
"abp-zero-template": {
"root": "",
"sourceRoot": "src",
"projectType": "application",
"architect": {
"build": {
"builder": "@angular-devkit/build-angular:browser",
"options": {
"allowedCommonJsDependencies": [
"@angularclass/hmr",
"rtl-detect",
"object-path",
"angular2-text-mask",
"angular2-counto",
"rxjs/internal/observable/throwError"
],
"outputPath": "wwwroot/dist",
"index": "src/index.html",
"main": "src/main.ts",
"tsConfig": "src/tsconfig.app.json",
"polyfills": "src/polyfills.ts",
"preserveSymlinks": true,
"assets": [
"src/assets",
"src/metronic",
"src/favicon.ico",
{
"glob": "abp.signalr-client.js",
"input": "node_modules/abp-web-resources/Abp/Framework/scripts/libs",
"output": "/assets/abp"
},
{
"glob": "**/*.*",
"input": "node_modules/primeng/resources/themes/mdc-light-indigo/",
"output": "assets/primeng/themes/mdc-light-indigo/"
},
{
"glob": "**/*.*",
"input": "node_modules/primeng/resources/themes/mdc-dark-indigo/",
"output": "assets/primeng/themes/mdc-dark-indigo/"
}
],
"styles": [
"node_modules/animate.css/animate.min.css",
"node_modules/quill/dist/quill.core.css",
"node_modules/quill/dist/quill.snow.css",
"node_modules/famfamfam-flags/dist/sprite/famfamfam-flags.css",
"node_modules/primeng/resources/primeng.min.css",
"node_modules/primeicons/primeicons.css",
"node_modules/sweetalert2/dist/sweetalert2.css",
"node_modules/cookieconsent/build/cookieconsent.min.css",
"src/assets/FreezeUI/freeze-ui.min.css",
"src/assets/primeng/file-upload/css/primeng.file-upload.css",
"src/assets/primeng/autocomplete/css/primeng.autocomplete.less",
"src/assets/primeng/tree/css/primeng.tree.css",
"src/assets/primeng/context-menu/css/primeng.context-menu.css",
"src/assets/fonts/fonts-poppins.css",
"src/assets/fonts/fonts-roboto.css",
"src/assets/metronic/common/fonts/keenthemes-icons/ki.css",
"src/assets/ngx-bootstrap/bs-datepicker.css",
"src/assets/metronic/vendors/global/vendors.bundle.css",
"src/app/shared/core.less",
"src/app/shared/layout/layout.less",
"src/styles.css"
],
"scripts": [
"node_modules/@microsoft/signalr/dist/browser/signalr.min.js",
"node_modules/localforage/dist/localforage.js",
"node_modules/push.js/bin/push.js",
"node_modules/quill/dist/quill.js",
"node_modules/sweetalert2/dist/sweetalert2.js",
"node_modules/cookieconsent/build/cookieconsent.min.js",
"src/assets/abp-web-resources/abp.js",
"src/assets/abp-web-resources/abp.sweet-alert.js",
"src/assets/abp-web-resources/abp.notify.js",
"src/assets/canvas-toBlob/canvas-toBlob.js",
"src/assets/metronic/vendors/global/vendors.bundle.js",
"src/assets/metronic/common/js/components/menu.js",
"src/assets/metronic/common/js/components/offcanvas.js",
"src/assets/metronic/common/js/components/header.js",
"src/assets/metronic/common/js/components/scrolltop.js",
"src/assets/metronic/common/js/components/toggle.js",
"src/assets/metronic/common/js/components/util.js",
"node_modules/jquery/dist/jquery.min.js"
],
"vendorChunk": true,
"extractLicenses": false,
"buildOptimizer": false,
"sourceMap": true,
"optimization": false,
"namedChunks": true
},
"configurations": {
"hmr": {
"budgets": [
{
"type": "anyComponentStyle",
"maximumWarning": "6kb"
}
],
"fileReplacements": [
{
"replace": "src/environments/environment.ts",
"with": "src/environments/environment.hmr.ts"
}
]
},
"production": {
"budgets": [
{
"type": "anyComponentStyle",
"maximumWarning": "6kb"
}
],
"optimization": true,
"outputHashing": "all",
"sourceMap": false,
"extractCss": true,
"namedChunks": false,
"extractLicenses": true,
"vendorChunk": false,
"buildOptimizer": true,
"fileReplacements": [
{
"replace": "src/environments/environment.ts",
"with": "src/environments/environment.prod.ts"
}
]
},
"k8s": {
"budgets": [
{
"type": "anyComponentStyle",
"maximumWarning": "6kb"
}
],
"optimization": true,
"outputHashing": "all",
"sourceMap": false,
"extractCss": true,
"namedChunks": false,
"extractLicenses": true,
"vendorChunk": false,
"buildOptimizer": true,
"fileReplacements": [
{
"replace": "src/environments/environment.ts",
"with": "src/environments/environment.k8s.ts"
}
]
}
},
"defaultConfiguration": ""
},
"serve": {
"builder": "@angular-devkit/build-angular:dev-server",
"options": {
"browserTarget": "abp-zero-template:build"
},
"configurations": {
"hmr": {
"browserTarget": "abp-zero-template:build:hmr"
},
"production": {
"browserTarget": "abp-zero-template:build:production"
},
"k8s": {
"browserTarget": "abp-zero-template:build:k8s"
}
}
},
"extract-i18n": {
"builder": "@angular-devkit/build-angular:extract-i18n",
"options": {
"browserTarget": "abp-zero-template:build"
}
},
"test": {
"builder": "@angular-devkit/build-angular:karma",
"options": {
"tsConfig": "src/tsconfig.spec.json",
"main": "src/test.ts",
"karmaConfig": "./karma.conf.js",
"polyfills": "src/polyfills.ts",
"styles": [
"node_modules/animate.css/animate.min.css",
"node_modules/quill/dist/quill.core.css",
"node_modules/quill/dist/quill.snow.css",
"node_modules/famfamfam-flags/dist/sprite/famfamfam-flags.css",
"node_modules/primeng/resources/primeng.min.css",
"node_modules/primeicons/primeicons.css",
"node_modules/sweetalert2/dist/sweetalert2.css",
"node_modules/cookieconsent/build/cookieconsent.min.css",
"src/assets/primeng/file-upload/css/primeng.file-upload.css",
"src/assets/primeng/autocomplete/css/primeng.autocomplete.less",
"src/assets/primeng/tree/css/primeng.tree.css",
"src/assets/primeng/context-menu/css/primeng.context-menu.css",
"src/assets/fonts/fonts-poppins.css",
"src/assets/fonts/fonts-roboto.css",
"src/assets/metronic/common/fonts/keenthemes-icons/ki.css",
"src/assets/ngx-bootstrap/bs-datepicker.css",
"src/assets/metronic/vendors/global/vendors.bundle.css",
"src/app/shared/core.less",
"src/app/shared/layout/layout.less",
"src/styles.css"
],
"scripts": [
"node_modules/@microsoft/signalr/dist/browser/signalr.min.js",
"node_modules/localforage/dist/localforage.js",
"node_modules/push.js/bin/push.js",
"node_modules/quill/dist/quill.js",
"node_modules/sweetalert2/dist/sweetalert2.js",
"node_modules/cookieconsent/build/cookieconsent.min.js",
"src/assets/abp-web-resources/abp.js",
"src/assets/abp-web-resources/abp.sweet-alert.js",
"src/assets/abp-web-resources/abp.notify.js",
"src/assets/canvas-toBlob/canvas-toBlob.js",
"src/assets/metronic/vendors/global/vendors.bundle.js",
"src/assets/metronic/common/js/components/menu.js",
"src/assets/metronic/common/js/components/offcanvas.js",
"src/assets/metronic/common/js/components/header.js",
"src/assets/metronic/common/js/components/scrolltop.js",
"src/assets/metronic/common/js/components/toggle.js",
"src/assets/metronic/common/js/components/util.js"
],
"assets": [
"src/assets",
"src/favicon.ico",
{
"glob": "abp.signalr-client.js",
"input": "node_modules/abp-web-resources/Abp/Framework/scripts/libs",
"output": "/assets/abp"
},
{
"glob": "**/*.*",
"input": "node_modules/primeng/resources/themes/mdc-light-indigo/",
"output": "assets/primeng/themes/mdc-light-indigo/"
},
{
"glob": "**/*.*",
"input": "node_modules/primeng/resources/themes/mdc-dark-indigo/",
"output": "assets/primeng/themes/mdc-dark-indigo/"
}
]
}
},
"lint": {
"builder": "@angular-devkit/build-angular:tslint",
"options": {
"tsConfig": [
"src/tsconfig.app.json"
],
"exclude": []
}
}
}
},
"abp-zero-template-e2e": {
"root": "",
"sourceRoot": "",
"projectType": "application",
"architect": {
"e2e": {
"builder": "@angular-devkit/build-angular:protractor",
"options": {
"protractorConfig": "./protractor.conf.js",
"devServerTarget": "abp-zero-template:serve",
"port": 4200
}
},
"lint": {
"builder": "@angular-devkit/build-angular:tslint",
"options": {
"tsConfig": [
"e2e/tsconfig.json"
],
"exclude": []
}
}
}
}
},
"defaultProject": "abp-zero-template",
"schematics": {
"@schematics/angular:component": {
"prefix": "app",
"style": "css"
},
"@schematics/angular:directive": {
"prefix": "app"
}
}
}
Hi @ismcagdas Thanks for giving reference. but no solution is working for me.
Hi i was using jquery builder query-builder.standalone file in old project but if i am trying to merge that file in newly migrated version folder it is giving me error like this-
Hi after successfully version migration i am trying to call some apis to fetch records for the components.
But i am getting this error
I debugged the code and found that while adding parameters to sqlquery it is giving exception. command.Parameters.Add(parameter)from this line in Databasehelper.cs file in create command method it is giving exception.
in development enviorment. We have migrated to new version so new abp tables are created where we need to set that tenantid