Community
 
 
 

CloudPortal Business Manager 2.x

팔로워 324명
 
Avatar
Pankaj Paliwal

$0 utility charge ??

Avatar

$0 utility charge ??

Hi

 

it is always showing $0 for Utility Charges in "Usage and Billing" for activity, subscription and invoice?

 

 

I can see usage data from my usage table and i have tried different bundle pack, but still no luck for utility charge, it is always showing $0.

 

any help would be appreciated !

 

thanks

Chris


Chris Lai MEMBERS
댓글 4개
0

댓글을 남기려면 로그인하세요.

 
 

Previous 댓글 4개

Avatar
Pankaj Paliwal
Avatar

$0 utility charge ??

Chris,

 

Can we verify a couple of things.

 

1. The subscribed bundle has entitlements (if it has, the usage may be counted against that).

2. The Job Manager job ran successfully (you may have usage in the usage table, but it may not be getting pulled properly into CPBM

3. The Close Out invoice (ie Invoices under Utility Charges + Other) are being generated (if you click on the detail, you will see line items. It should show you the calculations (ie usage, chargeable usage etc) daily


Vijaykumar Natarajan CITRIX EMPLOYEES
댓글 작업 고유 링크
Avatar
Pankaj Paliwal
Avatar

Hi Vijaykumar

 

 

1. The subscribed bundle doesn't has any entilements

2. for the Batch Job, do I need to setup a batch job to pull the data from usage to cpbm? or it will have some default scehdule job?

3.  I can see the Close out Invoice, but Utiltiy Charges also $0

 

and there is failed job in batch jobs list

 

ate:"Partially Erorr"

[org.springframework.dao.DataIntegrityViolationException: could not update: [com.vmops.usage.model.UserDailyUsage#3]; SQL [update user_daily_usage set billing_period_end_date=?, billing_period_sequence=?, billing_period_spend=?, billing_period_start_date=?, billing_period_usage=?, chargeable_usage=?, daily_spend=?, daily_usage=?, free_usage=?, last_update=?, product_id=?, rated=?, subscription_id=?, tenant_id=?, unit_price=?, updated_in_account_statement=?, usage_date=?, usage_unit=?, user_id=?, version=? where id=? and version=?]; nested exception is org.hibernate.exception.DataException: could not update: [com.vmops.usage.model.UserDailyUsage#3] at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:642) at org.springframework.orm.hibernate3.AbstractSessionFactoryBean.convertHibernateAccessException(AbstractSessionFactoryBean.java:303) at org.springframework.orm.hibernate3.AbstractSessionFactoryBean.translateExceptionIfPossible(AbstractSessionFactoryBean.java:282) at org.springframework.dao.support.ChainedPersistenceExceptionTranslator.translateExceptionIfPossible(ChainedPersistenceExceptionTranslator.java:58) at org.springframework.dao.support.DataAccessUtils.translateIfNecessary(DataAccessUtils.java:213) at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:163) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:155) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) at com.sun.proxy.$Proxy283.flush(Unknown Source) at com.vmops.billing.job.service.impl.UsageRatingService.process(UsageRatingService.java:116) at com.vmops.billing.job.service.impl.AccountBillingProcessImpl.processAccountStatements(AccountBillingProcessImpl.java:73) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:622) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) at com.sun.proxy.$Proxy325.processAccountStatements(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:622) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309) at org.springframework.osgi.service.importer.support.internal.aop.ServiceInvoker.doInvoke(ServiceInvoker.java:58) at org.springframework.osgi.service.importer.support.internal.aop.ServiceInvoker.invoke(ServiceInvoker.java:62) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131) at o

Chris Lai MEMBERS
댓글 작업 고유 링크
Avatar
Pankaj Paliwal
Avatar

Chris,

 

This looks like your billing job failed (yes, there are default jobs that run. No need to schedule explicitly). Looking at the error, it looks like the pricing and/or units for some product is unrealistic.

 

The usage that we are trying to record seems to have overrun the DB precision. Please check your products to see if your conversion factors are correct. For example, consider Network Data Transfer. Ideally, you should charge for it in GBs and not in lower units. If you, say, used bytes instead then the total amount of usage that one accrues is significantly higher than should be expected (ie instead of 1 GB of data transfer, you will get 1000000000 bytes of data transfer). Note the system will still accurately measure the usage, so you may get usage in fractions of GB (for eg. 0.131231311 GB).

 

So, please check the price per unit and units for your products.


Vijaykumar Natarajan CITRIX EMPLOYEES
댓글 작업 고유 링크
Avatar
Pankaj Paliwal
Avatar

Hi Vijaykumar

 

 

After  I re-config the product/catalog, now it is working, but i am not quite sure which one cause the problem ....

 

it is possible i can change the default schedule to run more frequently? let say every 5 mins for testing propose ? seem now the batch job is only run at 6:00 pm for everyday

 

The Citrix eDoc saying that I can change the job schedule by editing "applicationContext-jobs.xml" & "applicationContext-scheduler.xml" and restart cloud-portal service afterward.

 

but after i have edited xml file the  restarted the cloud-portal service, it doesn't seem take any effect and the xml file just roll back to the previous content??

 

and there are two folder contain the mentioned xml and i tried both, but still didn't change the schedule frequent

 

 .... /2.1.0/citrix.cpbm.custom.common-2.1.0.jar/"applicationContext-jobs.xml

 

and

 

..../2.1.0/citrix.cpbm.custom.common-2.1.0.jar-past/applicationContext-jobs.xml

 

 

thanks 

 

Chris


Chris Lai MEMBERS
댓글 작업 고유 링크

Top Contributors